BigQuery Create table copy

Create table copy copies the table structure, partition & clustering, table options as well as data into a new table

Create table copy example

CREATE TABLE mydataset.New_Employee
    COPY mydataset.Employee

Explanation

The CREATE TABLE COPY statement copies both the metadata and data from the source table.

The new table has no relationship to the source table after creation; thus modifications to the source table will not propagate to the new table.

The new table inherits partitioning and clustering from the source table. By default, the table options metadata from the source table are also inherited. Though you can customize table options in the new table by using the OPTIONS clauses in the SQL statement. The behavior is equivalent to running ALTER TABLE SET OPTIONS after the table has been copied.

Syntax reference

{CREATE TABLE | CREATE TABLE IF NOT EXISTS | CREATE OR REPLACE TABLE}
[[project_name.]dataset_name.]table_name
COPY [[project_name.]dataset_name.]source_table_name
[OPTIONS(table_option_list)]