MSCEWI3046

Alter Table syntax is not applicable in Snowflake.

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

Severity

Medium

Description

The Alter Table syntax used is not applicable in Snowflake, then the code is commented out and this message is being added.

Example Code:

Input Code:

ALTER TABLE SOMENAME DEFAULT COLLATION SOMENAME;

ALTER TABLE SOMENAME ROW ARCHIVAL;

ALTER TABLE SOMENAME MODIFY CLUSTERING;

ALTER TABLE SOMENAME DROP CLUSTERING;

ALTER TABLE SOMENAME SHRINK SPACE COMPACT CASCADE;

Output Code:

-- ** MSC-ERROR - MSCEWI3046 - ALTER TABLE SYNTAX NOT APPLICABLE IN SNOWFLAKE **
--ALTER TABLE PUBLIC.SOMENAME DEFAULT COLLATION SOMENAME
                                                      ;

-- ** MSC-ERROR - MSCEWI3046 - ALTER TABLE SYNTAX NOT APPLICABLE IN SNOWFLAKE **
--ALTER TABLE PUBLIC.SOMENAME ROW ARCHIVAL
                                        ;

-- ** MSC-ERROR - MSCEWI3046 - ALTER TABLE SYNTAX NOT APPLICABLE IN SNOWFLAKE **
--ALTER TABLE PUBLIC.SOMENAME MODIFY CLUSTERING
                                             ;

-- ** MSC-ERROR - MSCEWI3046 - ALTER TABLE SYNTAX NOT APPLICABLE IN SNOWFLAKE **
--ALTER TABLE PUBLIC.SOMENAME DROP CLUSTERING
                                           ;

-- ** MSC-ERROR - MSCEWI3046 - ALTER TABLE SYNTAX NOT APPLICABLE IN SNOWFLAKE **
--ALTER TABLE PUBLIC.SOMENAME SHRINK SPACE COMPACT CASCADE
                                                        ;

Recommendations

• No additional user actions are required.

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