Google BigQuery Create (DDL/Schema & Table Create expression) + Argument

Google BigQuery DDL - Schema/table create expression

CREATE TABLE [ IF NOT EXISTS ]
table_name
[(
column[, ...]
)]
[DEFAULT COLLATE collate_specification]
[PARTITION BY partition_expression]
[CLUSTER BY clustering_column_list]
[OPTIONS(table_option_list)]
[AS query_statement]

CREATE SCHEMA mydataset
OPTIONS
(
  location
="us",
  default_table_expiration_days
=3.75,
  labels
=[("label1","value1"),("label2","value2")]
 
)
CREATE SCHEMA mydataset
OPTIONS
(
  is_case_insensitive
=TRUE
)
CREATE SCHEMA mydataset
DEFAULT COLLATE 'und:ci'
CREATE SCHEMA mydataset
DEFAULT COLLATE 'und:ci'

Comments

Popular Posts