This is a deprecated version of the SnowConvert documentation, please visit the official site .
Severity
Low
Description
This message appears when a transformable Custom Type is defined, to add feedback about the transformable Custom Types being commented.
The type definition is commented but still being taken into account for resolving usages, see and for more information.
Example code
Input Code (Oracle):
CREATE TYPE type1 AS OBJECT (column1 INT);
CREATE OR REPLACE PROCEDURE record_procedure
IS
TYPE record_typ IS RECORD(col1 INTEGER, col2 FLOAT);
BEGIN
NULL;
END;
Output Code:
-- ** MSC-WARNING - MSCEWI1056 - CUSTOM TYPES ARE NOT SUPPORTED IN SNOWFLAKE BUT REFERENCES TO THIS CUSTOM TYPE WERE CHANGED TO VARIANT **
--CREATE TYPE type1 AS OBJECT (column1 INT);
CREATE OR REPLACE PROCEDURE PUBLIC.record_procedure ()
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
-- ** MSC-WARNING - MSCEWI1056 - CUSTOM TYPES ARE NOT SUPPORTED IN SNOWFLAKE BUT REFERENCES TO THIS CUSTOM TYPE WERE CHANGED TO OBJECT **
-- TYPE record_typ IS RECORD(col1 INTEGER, col2 FLOAT)
;
BEGIN
NULL;
END;
$$;
