Capturing DBQL Using Account String - 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

Teradata recommends that you specify the requests to capture using DBQL in the account string, using 10 to 40 different account strings based on different system workloads. Characterize the difference between work groups using four characters that identify the work group based on workload characteristics, such as business priority. By differentiating work groups in the account string, you can report usage (such as CPU consumption) by account string. The recommended account string format is '$M00ABCD&D&H'.

Logging DBQL by account string minimizes the logging rules and avoids having to log a DBQL rule every time a user ID is created.

You cannot log use count information for account strings.