MSCEWI1024

The following check constraint was commented out.

Severity
Low
Description
This warning is used to indicate that the check constraint of a specific column is commented out because it is not supported by Snowflake.
Example Code
Input Code:
CREATE TABLE CHECK_CONSTRAINT(
  "COLUMN2" VARCHAR(20) DEFAULT 'A Description' CHECK( "COLUMN2" IS NOT NULL ),
  "COLUMN3" VARCHAR(20),
  "COLUMN4" VARCHAR(20)
);
Output Code:
CREATE TABLE PUBLIC.CHECK_CONSTRAINT (
"COLUMN2" VARCHAR(20) DEFAULT 'A Description'
-- ** MSC-WARNING - MSCEWI1024 - THE FOLLOWING CHECK CONSTRAINT WAS COMMENTED OUT **
--                                              CHECK( "COLUMN2" IS NOT NULL )
                                                                            ,
"COLUMN3" VARCHAR(20),
"COLUMN4" VARCHAR(20)
);
Recommendation
If this issue happens is because there is not Snowflake equivalent for the check constraint statement. 
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.

MSCEWI1023

MSCEWI1025

Last modified 1yr ago