MSC-RS0012
"DISTKEY" statement on the column should be moved to table options by "CLUSTER BY".
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
Redshift's documentation for column attributes includes an optional clause that specifies if it is the distribution key for the table.
This warning is generated because the "DISTKEY" is located in the column as an attribute on RedShift but the equivalence on Snowflake is located in table options.
Code Examples
Recommendations
If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated