Links

MSCEWI2084

Transaction and profile level query tags not supported in Snowflake, referencing session query tag instead

Severity

Medium

Description

Teradata allows users to define query bands at transaction, session and profile levels, as well as consulting them with functions like GetQueryBandValue.
Snowflake equivalent for query bands is the query_tag parameter, which can be set for session, user or account. Also, Snowflake does not have profiles.
Due to these differences this EWI is added to warn the user that transaction or profile level query tags can not be defined neither consulted in Snowflake and that session level query tag will be used as a replacement, which may cause functional differences in some cases.

Example code

Input code

SELECT GETQUERYBANDVALUE(3, 'account');

Output code

SELECT
/** MSC-ERROR - MSCEWI2084 - TRANSACTION AND PROFILE LEVEL QUERY TAGS NOT SUPPORTED IN SNOWFLAKE, REFERENCING SESSION QUERY TAG INSTEAD **/
GETQUERYBANDVALUE_UDF('account');

Recommendations

  • Modify your code logic to use query bands at session level.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.