MSCEWI1055

Data Type Not Recognized

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.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI1054

MSCEWI1056

Last modified 8mo ago