MSC-RS0012

"DISTKEY" statement on the column should be moved to table options by "CLUSTER BY".

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

Severity

Low

Description

Redshift's documentation for column attributes includes an optional clause that specifies if it is the distribution key for the table.

This warning is generated because the "DISTKEY" is located in the column as an attribute on RedShift but the equivalence on Snowflake is located in table options.

Code Examples

Redshift input

CREATE TABLE TABLE1 
(
 COL1 INT DISTKEY,
 COL2 VARCHAR(15)
);

Snowflake output

CREATE TABLE TABLE1
(
 COL1 INT
--          --** MSC-WARNING - MSC-RS0012 - DISTSTYLE ON THE COLUMN SHOULD BE MOVED TO TABLE OPTIONS BY CLUSTER BY. **
--          DISTKEY
                 ,
 COL2 VARCHAR(15)
)
CLUSTER BY (COL1);                         

Recommendations

• If you need more support, you can email us at [e-mail]