GETQUERYBANDVALUE
Translation specification for the transformation of GetQueryBandValue to Snowflake
Last updated
Translation specification for the transformation of GetQueryBandValue to Snowflake
Last updated
The GetQueryBandValue function searches a name key inside of the query band and returns its associated value if present. It can be used to search inside the transaction, session, profile, or any of the key-value pairs of the query band.
For more information on this function check in the Teradata documentation.
1. GetQueryBandValue without QueryBandIn parameter only supported for session
Teradata allows defining query bands at transaction, session or profile levels. If GetQueryBandValue is called without specifying an input query band Teradata will automatically check the transaction, session or profile query bands depending on the value of the SearchType parameter.
In Snowflake the closest equivalent to query bands are query tags, which can be specified for session, user and account.
Due to these differences, the implementation of GetQueryBandValue without QueryBandIn parameter only considers the session query tag and may not work as expected for other search types.
No related EWIs.