Sets or removes a query band for the current session or transaction.
Middle-tier applications, through which end users access Vantage, can be programmed to use the SET QUERY_BAND statement to attach metadata to end user SQL queries.
You can also use query band names to do the following:
- Track activity using Viewpoint
- Filter requests for execution in addition to their use for Teradata Active System Management
- Set the binpacking algorithm to use when reading Parquet files
Vantage logs query bands in DBQL, providing opportunities for subsequent analysis of queries.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
IF you … | THEN you must be granted this privilege on your trusted user name … |
---|---|
do not have a need to submit SET QUERY_BAND requests to set a Proxy User | none. |
need to submit SET QUERY_BAND requests to set a proxy user | GRANT CONNECT THROUGH to a proxy user. See Teradata Vantage™ - SQL Data Control Language, B035-1149. |
must SET QUERY_BAND TVSTEMPERATURE = VERYHOT | EXECUTE on DBC.VHCTRL. |