Can a query tag be passed from Qlik Replicate to Snowflake?

[Datateam]

Hi
It is possible to pass a query tag from QR to Snowflake
from the endpoints odbc connection or from the Tasks themselves.
This would help us identify the different sources of change and analyze performance and costs.

Thanks.-

[john_wang]

Hello @Datateam ,

Thanks for reaching out to Qlik Community!

One of the method is adding an internal parameter afterConnectScript in Snowflake target endpoint, and set its value for example:

alter session set query_tag='your-queries-tags'

Where 'your-queries-tags' is the tag you want to be put on your queries inside of Snowflake.

Hope this helps.

John.

[Datateam]

Hi John

Thanks for the reply, however this solution only tags operations of the type USE, SET and ALTER_SESSION and what we want is to tag operations of the type DML and COPY, PUT_FILES, REMOVE_FILES, TRUNCATE_TABLE.

Thanks.

Hugo

[john_wang · Accepted solution]

Hi @Datateam ,

Thanks for the update. Personally I do not think there is an easy way to achieve that in Qlik Replicate. 

Regards,

John.