MSC-RS0005

"ENCODE encoding" statement has no equivalent in Snowflake.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

Redshift's documentation for column attributes or table attributes includes an optional clause that specifies the type of compression that is applied to table.

However, there is no equivalent command nor workaround to implement this functionality in Snowflake, furthermore, the Snowflake documentation says "When data is loaded into Snowflake, Snowflake reorganizes that data into its internal optimized, compressed, columnar format. Snowflake stores this optimized data in cloud storage."

This warning is generated to point out this difference in the architecture and to mark as invalid the functionality of the sentence.

Code Examples

Redshift input

CREATE TABLE table1
(col1 INTEGER ENCODE AZ64);

CREATE TABLE table2
(col1 INTEGER)
ENCODE AUTO;

Snowflake output

CREATE TABLE table1
(col1 INTEGER
--                 --** MSC-WARNING - MSC-RS0005 - ENCODING OPTION NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE. **
--                 ENCODE AZ64
                            );
                            
CREATE TABLE table2
(col1 INTEGER)
--                 --** MSC-WARNING - MSC-RS0005 - ENCODING OPTION NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE. **
--                 ENCODE AUTO
                            ;                            

Recommendations

• If you need more support, you can email us at [e-mail]