ENCODE

Description

The compression encoding for a column.

Click here to navigate to the Amazon Redshift docs page for this syntax.

ENCODE column attributes are removed because they are not applicable in Snowflake.

Grammar Syntax

ENCODE encoding

Sample Source Patterns

Amazon Redshift

Code

CREATE TABLE TABLE1 
(
 COL1 INT,
 COL2 VARCHAR(15) ENCODE TEXT255
);

Snowflake

Code

CREATE TABLE TABLE1
(
 COL1 INT,
 COL2 VARCHAR(15)
--                  --** MSC-WARNING - MSC-RS0005 - ENCODING OPTION NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE. **
--                  ENCODE TEXT255
);

Related EWIs

MCS-RS0005: "ENCODE encoding" statement has no equivalent in Snowflake.