MSC-RS0014

"SORTKEY" 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 attributes includes an optional clause that specifies if it is the sort key for the 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 SORTKEY,
 COL2 VARCHAR(15)
);

Snowflake output

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

Recommendations

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