Links

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.