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.
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]
Last updated