MSCEWI1062

Custom type usage changed to variant

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This message appears when a Custom Type is referenced, and then its usage is changed to variant.

This message is heavily related to MSCEWI1056 and MSCEWI1063.

Example code

Input Code (Oracle):

CREATE TYPE type1 AS OBJECT(type1_column1 INT);

CREATE TABLE table1
(
column1 type1
);

Output Code:

-- ** MSC-WARNING - MSCEWI1056 - CUSTOM TYPES ARE NOT SUPPORTED IN SNOWFLAKE BUT REFERENCES TO THIS CUSTOM TYPE WERE CHANGED TO A VARIANT **
--CREATE TYPE type1 AS OBJECT(type1_column1 INT);

CREATE TABLE table1
(
column1 VARIANT /*** MSC-WARNING - MSCEWI1062 - CUSTOM TYPE 'type1' USAGE CHANGED TO VARIANT ***/,
);

--** MSC-WARNING - MSCEWI1063 - ADDED STATEMENTS BECAUSE 'table2' USED A CUSTOM TYPE **
CREATE OR REPLACE VIEW PUBLIC.table2_view AS
SELECT
column1:type1_column1 :: INTEGER AS column1
FROM table1;

Recommendations

• Remember to transform all of its input data into a Variant-compliant data type as well.

• If you need more support, you can email us at [email protected]