MSCEWI1063

Added statements because object used a custom type

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

Severity

Low

Description

This message appears after a DDL statement, such as a Create Table, references a Custom Type within its elements due to the extra statements that were added to implement the same behaviour from the original DDL statement.

This message is heavily related to MSCEWI1056, MSCEWI1062 and MSCEWI1064.

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

• For queries into the original table, some statements must be changed, because at least one column was replaced by a Variant.

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