Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Other: HVR - Override standard query_tag for snowflake

Planned
Jean Feutrie User

Hello,

HVR currently applies a predefined standard tag in the form of a simple string  in Snowflake.
We would greatly appreciate having the ability to override the standard tag with our own.

This capability is important for us in order to accurately track and allocate Snowflake costs for ingestion process we execute using business tag.

We would prefer to create json like we do this with DBT.

Thank you in advance for considering this enhancement.

Please sign in to leave a comment.

Comments

7 comments

Date Votes
  • Official comment
    Edwin Fivetranner

    Hi Jean,

    I'm happy to report that the engineering work is done and this feature will be added to the next HVR EA release HVR 6.3.5/4

    Best regards,

    Edwin

  • Edwin Fivetranner

    Hi Jean,

    Thank you for reaching out with this enhancement request.

    To summarise what you are asking for:

    • Custom Snowflake tag override: ability to replace HVR's predefined standard tag string with your own tag, to support accurate cost tracking and allocation per ingestion process
    • Possible JSON tag format:

    This feature request will be discussed with the integration team and will come back ASAP.

    Best regards,

    Edwin

  • Jean Feutrie User

    Hello Edwin,

    thanks for your feedback.

    Example of JSON /query make on snowflake session : 

    alter session set query_tag = '{"APP": "FIVETRAN", "PROJECT": "X", "DOMAINE": "FINANCE"}'

    Regards

    Jean

  • Edwin Fivetranner

    Thank you Jean,

    I've added this example to the Feature Request...

    Best regards,

    Edwin

  • Edwin Fivetranner

    Hi Jean, we have looked at your input and we see two options to fullfil this request:

    1. append in the end of query_tag: HVR: hub_pid=123,agent_pid=456,...,user_tag={{"APP":"FIVETRAN","PROJECT":"X","DOMAINE":"FINANCE"}}
    2. use the query_comment: alter session set query_tag = 'HVR: hub_pid=123,...'; alter session set query_comment = '{"APP":"FIVETRAN","PROJECT":"X"}';

    Which option would best suit your purpose?

    Best regards,

    Edwin

  • Jean Feutrie User

    Hello Edwin,

    Thanks for the proposal, as I see we cannot override.

    The first proposal is better for us.

    Thanks

    Jean

  • Edwin Fivetranner

    Ok we do option one. The reason we need to keep out part of the tag is that it is required for our own internal job management.

    I will let you know when there is progress to report

    Best regards.

    Edwin