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
Sample Source Patterns
RedShift Input Code:
IN -> Redshift_01.sql
Snowflake Output Code:
OUT -> Redshift_01.sql
Related EWIs
There are no known issues.
Last updated