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)
              ;
  1. MCS-RS0014: SORTKEY option not supported. Data storage is automatically handled by Snowflake

Last updated