MSCEWI1035

Check statement not supported.

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

Severity

Low

Description

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

Example Code

Oracle Input Code:

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

Output Code:

CREATE OR REPLACE TABLE "Schema"."BaseTable" (
    "COLLUMN1" VARCHAR(255) /*** MSC-WARNING - MSCEWI1036 - VARCHAR2 DATA TYPE CONVERTED TO VARCHAR ***/,
--    --** MSC-WARNING - MSCEWI1035 - CHECK STATEMENT NOT SUPPORTED **
--    CHECK ( COLUMN1 IS NOT NULL )
  );

Recommendations

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