MSCEWI1055
Data Type Not Recognized
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
This error happens when the definition for a Custom Type was not found or an Oracle built-in data type was not recognized by Snow Convert.
Example code
Input Code (Oracle):
--Type was never defined
--CREATE TYPE type1;
CREATE TABLE table1
(
column1 type1
column2 unrecognizedType
);
Output Code:
--Type was never defined
--CREATE TYPE type1;
CREATE OR REPLACE TABLE PUBLIC.table1 (
column1 VARIANT /*** MSC-WARNING - MSCEWI1055 - DATA TYPE 'type1' NOT RECOGNIZED ***/,
column2 VARIANT /*** MSC-WARNING - MSCEWI1055 - DATA TYPE 'unrecognizedType' NOT RECOGNIZED ***/);
Recommendations
Verify that the type that the referenced data type was defined in the input code.
Check the Snowflake data types documentation to find an equivalent for the data type.
If you need more support, you can email us at [email protected]
Last updated