SORTKEY
Description
Constraint that specifies the column to be used as the distribution key for the table.
Click here to navigate to the Amazon Redshift docs page for this syntax.
SORTKEY (column) attribute is removed because they are not applicable in Snowflake.
Grammar Syntax
[COMPOUND | INTERLEAVED ] SORTKEY ( column_name [,...]) | [ SORTKEY AUTO ]
Sample Source Patterns
Amazon Redshift
CREATE TABLE TABLE1
(
COL1 INT,
COL2 VARCHAR(15)
)
SORTKEY (COL1);
Snowflake
CREATE TABLE TABLE1
(
COL1 INT,
COL2 VARCHAR(15)
)
----** MSC-WARNING - MSC-RS0009 - SORTKEY OPTION NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE. **
--SORTKEY (COL1)
;
Related EWIs
MCS-RS0014: SORTKEY option not supported. Data storage is automatically handled by Snowflake
Last updated
Was this helpful?