This is a deprecated version of the SnowConvert documentation, please visit the official site .
This error happens when there is a mismatch in a foreign key data type.
CREATE TABLE "MyDb"."MyTable"
(
"COL1" NUMBER,
CONSTRAINT "PK" PRIMARY KEY ("COL1")
);
CREATE TABLE "MyDb"."MyTable1"
(
"COL1" NUMBER(*,0),
CONSTRAINT "FK1" FOREIGN KEY ("COL1") REFERENCES "MyDb"."MyTable" ("COL1")
);
CREATE OR REPLACE TABLE MyDb.MyTable ( COL1 NUMBER (38,19),
CONSTRAINT PK PRIMARY KEY (COL1));
CREATE OR REPLACE TABLE MyDb.MyTable1 ( COL1 NUMBER (38,0),
/*** MSC-ERROR - MSCEWI3002 - FOREIGN KEY DATA TYPE MISMATCH ***/
/* CONSTRAINT FK1 FOREIGN KEY (COL1) REFERENCES MyDb.MyTable (COL1)*/);