MSCEWI2027

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

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