Create and Maintain Query Lists | VantageCloud Lake - Creating and Maintaining Query Lists - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

A query list allows you to identify and analyze a set of queries based on arbitrary user-defined criteria.

Query List open APIs use one or more DBQL query IDs that are associated with a named identifier. This identifier can be passed to the Analyzer open API, AnalyzeStatsUsage, as an input argument. For more information about this open API, see AnalyzeStatsUsage.

You can use these open APIs to create and maintain query lists.

Functionality

Goal SQL Interface to Use
Create a new query list AddQueryList.
Add a query to a named list AddQueryListEntry.
Drop a list and all queries within it RemoveQueryList.
Drop an individual query from a list RemoveQueryListEntry.