MSCEWI2084

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

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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 the session level.

• If you need more support, you can email us at [email protected]