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.
