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
Post a Comment