MSCEWI5003
PERIOD DEFINITION IS NOT SUPPORTED IN SNOWFLAKE.
Last updated
PERIOD DEFINITION IS NOT SUPPORTED IN SNOWFLAKE.
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Medium
DB2 temporal tables do not have a functional equivalent in Snowflake. When an application-period or system-period temporal table declaration is found in the CREATE TABLE
columns, that column is commented out from the resulting script. The behavior of the SELECT statement will differ from Snowflake due that temporal tables are not part of the Snowflake solution and this causes the result to be different if the Select statement is migrated partially, see the example below for more information about this.
If the Select statement is migrated partially we get a very different result as shown below. For this reason, the complete Select statement will be commented out with this EWI
Snowflake allows the storage of historical table data for up to 90 days, to know more about this see .
If you need more support, you can email us at