17.10 - SET SESSION TTGRANULARITY TO Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1182-171K
Language
English (United States)
SET SESSION TTGRANULARITY TO { LOGICALROW | REQUEST | TRANSACTION }

Syntax Elements

LOGICALROW
Row is timestamped with the time the row is processed by the AMP.
REQUEST
Row is timestamped with the time the request is submitted.
TRANSACTION
Row is timestamped with the time when the first non-locking reference is made to a temporal table, or when the built-in function TEMPORAL_TIMESTAMP is first accessed during the transaction.