Period Definition

Description

Defines a period of time in which the data of a row is valid.

PERIOD-DEFINITION does not have a functional equivalent in Snowflake.

Snowflake allows the storage of historical table data for up to 90 days, to know more about this see Understanding & Using Time Travel.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

CREATE TABLE T1(
COL1 DATE,
COL2 DATE,
PERIOD SYSTEM_TIME (COL1, COL2)
)

Snowflake

CREATE TABLE PUBLIC.T1(
COL1 DATE,
COL2 DATE
-- MSC-WARNING - MSCEWI5003 - PERIOD DEFINITION IS NOT APPLICABLE IN SNOWFLAKE.
-- PERIOD SYSTEM_TIME (COL1, COL2)
)

Related EWIs

1. MSCEWI5003: Period definition is not applicable in Snowflake.