MSC-BQ0001

The Create Table OPTIONS clause is not supported in Snowflake.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium (waiting for CoE revision)

Description

This warning is added to the Create Table statement when the OPTIONS clause is included there.

Code Example

Input Code:

Input.sql

CREATE TABLE mydataset.newtable
LIKE sourceTable
OPTIONS(expiration_timestamp=TIMESTAMP ""2025 - 01 - 01 00:00:00 UTC"");

Output Code:

Output.sql

CREATE TABLE mydataset.newtable
LIKE sourceTable
-- ** 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"")
                                                                     ;

Recommendations

• For the description option in the create table options clause which is a user-friendly description of the table, in Snowflake exists a comment clause that adds a comment or overwrites an existing comment for an existing object. These may have similar functionalities to be considered.

• Add manual changes to the not transformed expression.

• If you need more support, you can email us at [email protected]