This error happens when the definition for a Custom Type was not found or an Oracle built-in data type was not recognized by SnowConvert.
Example code
Input Code (Oracle):
Output Code:
Recommendations
Verify that the type that the referenced data type was defined in the input code.
Check the Snowflake data types to find an equivalent for the data type.
If you need more support, you can email us at
IN -> SqlServer_01.sql
--Type was never defined
--CREATE TYPE type1;
CREATE TABLE table1
(
column1 type1
);
OUT -> SqlServer_01.sql
--Type was never defined
--CREATE TYPE type1;
CREATE OR REPLACE TABLE table1
(
column1 VARIANT /*** SSC-FDM-TS0015 - DATA TYPE TYPE1 IS NOT SUPPORTED IN SNOWFLAKE ***/
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"transact"}}'
;