OPTIONS CLAUSE
Create table option
Description
The option list allows you to set table options such as a label and an expiration time. For more information please refer to Table Option List.
Options clause is not supported by Snowflake.
Sample Source
BigQuery (Input Code)
CREATE TABLE table1
(
col1 INT,
col2 DATE
)
OPTIONS(
expiration_timestamp=TIMESTAMP "2025-01-01 00:00:00 UTC",
partition_expiration_days=1,
description="a table that expires in 2025, with each partition living for 24 hours",
labels=[("org_unit", "development")]
);
Snowflake (Output Code)
CREATE TABLE table1
(
col1 INT,
col2 DATE
)
----** MSC-ERROR - MSC-BQ0001 - THE CREATE TABLE OPTIONS CLAUSE IS NOT SUPPORTED IN SNOWFLAKE. **
--OPTIONS(
-- expiration_timestamp=TIMESTAMP "2025-01-01 00:00:00 UTC",
-- partition_expiration_days=1,
-- description="a table that expires in 2025, with each partition living for 24 hours",
-- labels=[("org_unit", "development")])
;
Related EWIs
MSC-BQ0001: The Create Table OPTIONS clause is not supported in Snowflake.
Last updated
Was this helpful?