QryLogSQLDocV - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

Category: Query

Database: DBC

View Column Data Type Format Description
ProcID DECIMAL(5,0) NOT NULL -(5)9 The process ID of the dispatcher.
CollectTimeStamp TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(6) (Prime Key) Time and date when the DBQL SQL cache was written.
QueryID DECIMAL(18,0) NOT NULL --Z(17)9 System-wide unique ID to identify the query.
SqlTextDoc CLOB(1048544000) UNICODE NOT CASESPECIFIC X(32000) Full SQL text segment unless an error is encountered, or the SQL is aborted.
ParentReqStartTime TIMESTAMP(6) YYYY-MMDDBHH:MI:SS.S(6) The time when the parent request was submitted.
ParentQueryID DECIMAL(18,0) --Z(17)9 The parent system generated query id for this query.