Teradata Query Banding For In-DB Tools

[rdoptis]

Teradata has a feature called query banding where a group of queries or more commonly a database session can have additional metadata tagged onto all of the individual queries. The Teradata workload management engine can use information provided in the query band for use in prioritizing query execution and resource allocation.

With normal input tools, the query band information can be populated in the "Pre-SQL" with a query such as:

SET QUERY_BAND = 'org=Finance;report=Fin123;' FOR SESSION;

However, with the In-DB tools, there is no concept of pre-SQL, and no great way to set the query band for the In-DB queries Alteryx submits. We would want to set the query band at the workflow level for performance prioritization and resource allocation monitoring purposes. 

Best regards,
Ryan

[Atabarezz]

Would be an interesting and nice feature..

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!

[joncampbell]

I am trying to use pre-sql to send info to Teradata. This works fine for your example but I want to pass thru additional data the most important being the user. I have not been able to determine how to do this.

Any ideas on how to add user info to set query_band?

SET QUERY_BAND = 'org=Finance;report=Fin123;' FOR SESSION;

[yuriy]

We would like to implement it in the same way. We need to pass user account to TD for authorization as we currently doing it with some other products

[EKJohnson]

We also have this need.