DISTKEY
Description
In Amazon Redshift, DISTKEY
is used to distribute data across cluster nodes to optimize query performance. Snowflake, however, automatically handles data distribution and storage without needing explicit distribution keys. Due to differences in architecture and data management approaches, Snowflake does not have a direct equivalent to Redshift's DISTKEY
. For these reasons, the statement DISTKEY
is removed during the transformation process
Click here to navigate to the Amazon Redshift docs page for this syntax.
Grammar Syntax
DISTKEY ( column_name )
Sample Source Patterns
Input Code:
CREATE TABLE table1
DISTKEY (col1)
AS SELECT * FROM table_test;
Output Code:
CREATE TABLE table1
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "redshift", "convertedOn": "02/10/2025", "domain": "test" }}'
----** SSC-FDM-RS0001 - DISTKEY OPTION NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE. **
--DISTKEY (col1)
AS SELECT * FROM
table_test;
Related EWIs
SSC-FDM-RS0001: "Option" not supported. Data storage is automatically handled by Snowflake.
Last updated