MSCEWI2009

TEMPORAL column not supported.

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

Severity

Low

Description

Teradata provides temporal table support at the column level using derived period columns. These columns are not supported in Snowflake.

Code Example

Input Code:

CREATE TABLE T_2009
(
    COL1 INTEGER,
    PERIOD FOR Policy_Duration (Policy_Begin, Policy_End) AS PERIODTIME
);

Output Code:

CREATE TABLE PUBLIC.T_2009 (
COL1 INTEGER
/*** MSC-WARNING - MSCEWI2009 - TEMPORAL COLUMN NOT SUPPORTED ***/
/* PERIOD FOR Policy_Duration(Policy_Begin,Policy_End)AS VALIDTIME*/
);

Recommendations

• No additional user actions are required.

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