Links

MSCEWI1002

Removed next statement, not applicable in SnowFlake.

Severity

Low

Description

This warning appears when a specific statement is not applicable in Snowflake, it means that there is no Snowflake equivalent for this statement and it is no longer needed, and for that reason, it is removed from the source code. However, SnowConvert still keeps the original statement as part of the comment at the end.

Example Code

Input Code:

CREATE TABLE "Schema"."BaseTable"(
"PROPERTY" VARCHAR2(64) CONSTRAINT "MICROSOFT_NN_PROPERTY" NOT NULL ENABLE
);

Output Code:

CREATE OR REPLACE MobilizeSchema.PUBLIC.BaseTable
(
PROPERTY VARCHAR(64) NOT NULL /*** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. CONSTRAINT MICROSOFT_NN_PROPERTY ***/
);

Recommendation