google-big-queryHow do I set up a primary key in Google BigQuery?

Setting up a primary key in Google BigQuery is fairly simple. First, you must create a table in BigQuery. To do this, you can use the CREATE TABLE statement. For example:

CREATE TABLE my_table (
  id INT64,
  name STRING,
  age INT64
);

Once the table is created, you can set the primary key by using the ALTER TABLE statement. For example:

ALTER TABLE my_table ADD PRIMARY KEY (id);

The parts of the code are:

• CREATE TABLE: Used to create a new table.
• ALTER TABLE: Used to modify an existing table.
• ADD PRIMARY KEY: Used to set the primary key of the table.

Helpful links

• BigQuery Documentation: CREATE TABLE
• BigQuery Documentation: ALTER TABLE

Edit this code on GitHub