SSC-EWI-0028

Type not supported by Snowflake

Severity

Medium

Description

This message appears when a type is not supported in Snowflake.

Example

Input Code (Oracle):

IN -> Oracle_01.sql
CREATE TABLE MYTABLE
(
    COL1 SYS.ANYDATASET
);

Output Code:

OUT -> Oracle_01.sql
CREATE OR REPLACE TABLE MYTABLE
    (
    !!!RESOLVE EWI!!! /*** SSC-EWI-0028 - TYPE NOT SUPPORTED BY SNOWFLAKE ***/!!!
        COL1 SYS.ANYDATASET
    )
    COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"oracle"}}'
    ;

Recommendations

Last updated