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

1. MSC-BQ0001: The Create Table OPTIONS clause is not supported in Snowflake.