MSCEWI1024

The following check constraint was commented out.

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

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)
);

Recommendations

• If this issue happens is because there is no Snowflake equivalent for the check constraint statement.

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