SSC-EWI-TD0029

Queue table functionality is not supported.

Severity

Low

Description

This warning appears when a TABLE with the QUEUE attribute is migrated. The QUEUE keyword is removed because it is not supported in snowflake.

Example Code

Input:

IN -> Teradata_01.sql
CREATE MULTISET TABLE SAMPLE_TABLE,
QUEUE,
NO FALLBACK 
(
    COL1 INTEGER
);

Output:

OUT -> Teradata_01.sql
!!!RESOLVE EWI!!! /*** SSC-EWI-TD0029 - QUEUE TABLE FUNCTIONALITY NOT SUPPORTED ***/!!!
CREATE OR REPLACE TABLE SAMPLE_TABLE
(
    COL1 INTEGER
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"teradata"}}'
;

Recommendations

Last updated