This is a deprecated version of the SnowConvert documentation, please visit the official site .
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
;