MSC-RS0011

"DISTSTYLE" statement has no equivalent in Snowflake.

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.

However, there is no equivalent command nor workaround to implement this functionality in Snowflake, furthermore, the Snowflake documentation says "When data is loaded into Snowflake, Snowflake reorganizes that data into its internal optimized, compressed, columnar format. Snowflake stores this optimized data in cloud storage."

This warning is generated to point out this difference in the architecture and to mark as invalid the functionality of the sentence.

Code Examples

Redshift input

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

Snowflake output

CREATE TABLE TABLE1
(
 COL1 INT,
 COL2 VARCHAR(15)
)
----** MSC-WARNING - MSC-RS0011 - DISTSTYLE OPTION NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE. **
--DISTSTYLE ALL
             ;

Recommendations

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