MSCEWI2009

TEMPORAL column not supported.

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.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI2008

MSCEWI2010

Last modified 1yr ago