Table Properties

Create table option

Description

The TBLPROPERTIES clause allows you to tag the table definition with your own metadata key/value pairs.

TBLPROPERTIES clause is not supported by Snowflake.

Sample Source

Hive

CREATE TABLE table1 (
    col1 STRING 
) 
TBLPROPERTIES ("immutable"="true");

Snowflake

CREATE TABLE table1 (
    col1 STRING 
)
----** MSC-ERROR - MSC-HVXXXX - THE TBLPROPERTIES CLAUSE IS NOT SUPPORTED IN SNOWFLAKE. **
--TBLPROPERTIES ("immutable"="true");

Known Issues

No issues were found.

Related EWIs

1. MSC-HVXXXX: THE TBLPROPERTIES CLAUSE IS NOT SUPPORTED IN SNOWFLAKE.