Links

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.