MSCEWI4058

One or more of the table element parts are not supported in snowflake.

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

Severity

Medium

Description

This EWI occurs when there are unsupported table elements on the Alter Table statement.

If all the table elements are invalid, the whole Alter Table statement is commented out.

Code Example

Input code

ALTER TABLE table_name2
ADD column_name VARCHAR(255)
CONSTRAINT constraint_name 
CHECK NOT FOR REPLICATION (column_name > 1);

Output code:

ALTER TABLE IF EXISTS table_name2
ADD column_name VARCHAR(255)
----** MSC-ERROR - MSCEWI4058 - ONE OR MORE OF THE TABLE ELEMENT PARTS ARE NOT SUPPORTED IN SNOWFLAKE: CHECK COLUMN CONSTRAINT **
--CONSTRAINT constraint_name
--CHECK NOT FOR REPLICATION (column_name > 1)
                                           ;

Recommendations

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