Creating Temporal Tables - Analytics Database - Teradata Vantage

Temporal Table Support

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
eud1628112402879.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
fif1472244754791
lifecycle
latest
Product Category
Teradata Vantage™

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.