MSC-GP0000

Data storage is automatically handled by Snowflake

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

Severity

Low

Description

This warning is added to clauses related to data storage handling, this is because Snowflake automatically handles data storage. For more information on this subject, you can consult here.

Code Example

Input Code:

Encoding

CREATE TABLE TABLE1 (
   COL1 integer CONSTRAINT Cons1 UNIQUE ENCODING (compresstype = quicklz, blocksize = 65536)
)

Distributed clause

CREATE TEMPORARY TABLE temp_CINS (
   alt_cd6 varchar(30) NULL
)
DISTRIBUTED BY (alt_cd6);

CREATE TABLE table1 (
	col1 varchar(30)
)
DISTRIBUTED RANDOMLY;

CREATE TABLE table2 (
	col1 varchar(30)
)
DISTRIBUTED REPLICATED;

Output Code:

Encoding

CREATE TABLE PUBLIC.TABLE1 (
   COL1 integer CONSTRAINT Cons1 UNIQUE
-- ** MSC-WARNING - MSC-GP0000 - ENCODING OPTION NOT APPLICABLE. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE **
--                                        ENCODING (compresstype = quicklz, blocksize = 65536)
)

Distributed clause

CREATE TEMPORARY TABLE PUBLIC.temp_CINS (
	alt_cd6 varchar(30) NULL
)
-- ** MSC-WARNING - MSC-GP0000 - DISTRIBUTED TABLE OPTION NOT APPLICABLE. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE **
--distributed by (alt_cd6)
                        ;

CREATE TABLE PUBLIC.table1 (
	col1 varchar(30)
)
-- ** MSC-WARNING - MSC-GP0000 - DISTRIBUTED TABLE OPTION NOT APPLICABLE. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE **
--DISTRIBUTED RANDOMLY
                    ;

CREATE TABLE PUBLIC.table2 (
	col1 varchar(30)
)
-- ** MSC-WARNING - MSC-GP0000 - DISTRIBUTED TABLE OPTION NOT APPLICABLE. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE **
--DISTRIBUTED REPLICATED
                      ;

Recommendations

• No additional user actions are required, it is just informative.

• Add manual changes to the not transformed expression.

• If you need more support, you can email us at [email protected]