DISTKEY

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.

Grammar Syntax

DISTKEY ( column_name )

Sample Source Patterns

Amazon Redshift

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

Snowflake

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

Known issues

There are no known issues.