SSC-FDM-TD0019

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

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 FMD is added to warn the user that transaction or profile-level query tags can not be defined nor consulted in Snowflake and that session-level query tags will be used as a replacement, which may cause functional differences in some cases.

Example Code

Input Code:

IN -> Teradata_01.sql

SELECT GETQUERYBANDVALUE(3, 'account');

Output Code

OUT -> Teradata_01.sql

SELECT
--** SSC-FDM-TD0019 - 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 [e-mail]