Links

MSCEWI1035

Check statement not supported.

Severity

Low

Description

This warning appears to indicate the CHECK constraint is not supported by Snowflake but it does not affect functionally.

Example Code

Input Code:

CREATE TABLE "Schema"."BaseTable"(
"COLLUMN1" VARCHAR2(255),
CHECK ( COLUMN1 IS NOT NULL )
);

Output Code:

CREATE OR REPLACE TABLE MobilizeSchema.BaseTable ( COLLUMN1 VARCHAR(255)
/*** MSC-WARNING - MSCEWI1035 - CHECK STATEMENT NOT SUPPORTED ***/
/* CHECK ( COLUMN1 IS NOT NULL )*/);

Recommendation