ENCODE
Description
Enables Amazon Redshift to automatically adjust the encoding type for all columns in the table to optimize query performance
Click here to navigate to the Amazon Redshift docs page for this syntax.
ENCODE AUTO attribute is removed because they are not applicable in Snowflake.
Grammar Syntax
ENCODE AUTO
Sample Source Patterns
Amazon Redshift
CREATE TABLE TABLE1 (
COL1 INTEGER,
COL2 VARCHAR(30))
ENCODE AUTO;
Snowflake
CREATE TABLE TABLE1 (
COL1 INTEGER,
COL2 VARCHAR(30))
----** MSC-WARNING - MSC-RS0005 - ENCODING OPTION NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE. **
--ENCODE AUTO
;
Related EWIs
MCS-RS0005: ENCODING option not supported. Data storage is automatically handled by Snowflake.
Last updated
Was this helpful?