MSC-RS0013

DistStyle option is replaced by 'CLUSTER BY' on Snowflake using DISTKEY option.

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

Severity

Low

Description

Redshift's documentation for column table attributes includes an optional clause specifying the data distribution style for the whole table. This EWI only applies for DISTSTYLE KEY

Code Examples

Redshift input

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

Snowflake output

CREATE TABLE TABLE1
(
 COL1 INT,
 COL2 VARCHAR(15)
)
----** MSC-WARNING - MSC-RS0013 - DISTSTYLE KEY OPTION IS REPLACED BY CLUSTER ON SNOWFLAKE USING DISTKEY OPTION. **
--DISTSTYLE KEY
CLUSTER BY (COL1)
;                        

Recommendations

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