SORTKEY

Description

The keyword that specifies that the column is the sort key for the table.

Click here to navigate to the Amazon Redshift docs page for this syntax.

SORTKEY attribute is removed because they are not applicable in Snowflake.

Grammar Syntax

SORTKEY

Sample Source Patterns

Amazon Redshift

Code

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

Snowflake

Code

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

Related EWIs

MCS-RS0014: SORTKEY option not supported. Data storage is automatically handled by Snowflake.