Snowflake does not support Teradata built-in time dimensions column options
This warning appears because Snowflake does not support the Teradata built-in time dimensions attributes like
TRANSACTIONTIMEso they should be removed.
CREATE MULTISET TABLE SAMPLE_TABLE
COL1 PERIOD(TIMESTAMP(6) WITH TIME ZONE) NOT NULL AS TRANSACTIONTIME
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 ***/
- 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.