This is a deprecated version of the SnowConvert documentation, please visit the official site .
Severity
Low
Description
This warning appears because Snowflake does not support the 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 ***/
);
