Links

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.