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

1. MCS-RS0005: ENCODING option not supported. Data storage is automatically handled by Snowflake.