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

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

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]