MSCEWI4058

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

Severity
Medium
Description
This is 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:
1
ALTER TABLE IF EXISTS PUBLIC.table_name2
2
ADD column_name VARCHAR(255)
3
-- ** MSC-WARNING - MSCEWI1040 - THE STATEMENT IS NOT SUPPORTED IN SNOWFLAKE **
4
--                             CONSTRAINT constraint_name
5
--CHECK NOT FOR REPLICATION (column_name > 1)
6
                                           ;
Recommentations
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI4057

MSCEWI4059

Last modified 6mo ago