17.10 - Creating Temporal Tables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

This section describes tasks related to creating temporal tables.

Temporal tables are distinguished from nontemporal tables by having temporal columns: a valid-time column, a transaction-time column, or both. A temporal column can be derived from two individual DateTime columns representing the beginning and end of a duration, or it can be a true Period data type column that represents the duration as a single Teradata data type. Teradata recommends using derived temporal columns, because Vantage cannot collect statistics on temporal data in Period data type columns.