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 snowconvert-support@snowflake.com
Last updated