Specifies rules for assigning primary keys to tables.

データ型

string

デフォルト値

""

解説

Google BigQuery does not natively support primary keys. However, certain operations such as updates, deletes, or integrations with external tools may require primary key definitions. This property allows you to define primary keys manually using a semicolon-separated list of rules.

Each rule follows the format: <table_pattern>=<comma-separated list of columns>

For example: PrimaryKeyIdentifiers="*=key;transactions=tx_date,tx_serial;user_comments="

This defines three rules:

• *=key: All tables use key as the primary key unless overridden. Tables that do not contain a key column will not have a primary key.
• transactions=tx_date,tx_serial: The transactions table uses tx_date and tx_serial as composite primary keys. If either of those columns is missing from the table, no primary key is assigned.
• user_comments=: The user_comments table is explicitly configured to have no primary key, overriding the default.

Rules may match just the table name, the dataset and table, or the project, dataset, and table for increasing specificity:

/* Rules with just table names use the connection ProjectId (or DataProjectId) and DatasetId.
   All these rules refer to the same table when ProjectId=someProject and DatasetId=someDataset */
someTable=a,b,c
someDataset.someTable=a,b,c
someProject.someDataset.someTable=a,b,c

You may quote table and column names using any valid SQL quoting style:

/* Any table or column name may be quoted */
`someProject`."someDataset".[someTable]=`a`,[b],"c"

If this property is not set, the 本製品 uses schema files defined through Location to determine primary keys. Otherwise, all tables are treated as having no primary key by default.