MSCEWI2027

Snowflake does not support Teradata built-in time dimensions column options

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This warning appears because Snowflake does not support the Teradata built-in time dimensions attributes like VALIDTIME or TRANSACTIONTIME so they should be removed.

Code Example

Input Code:

CREATE MULTISET TABLE SAMPLE_TABLE   
(
    COL1 PERIOD(TIMESTAMP(6) WITH TIME ZONE) NOT NULL AS TRANSACTIONTIME
);      

Output Code:

CREATE TABLE PUBLIC.SAMPLE_TABLE
(
    COL1 VARCHAR(68) NOT NULL COMMENT 'PERIOD(TIMESTAMP(6) WITH TIME ZONE)' /*** MSC-WARNING - MSCEWI2027 - SNOWFLAKE DOES NOT SUPPORT 'TRANSACTIONTIME' COLUMN OPTION ***/
);

Recommendations

• If you need more support, you can email us at [email protected]