Application name or UserAgent info to Snowflake.

Help
1

The problem I’m having

When I connect to Snowflake using dbt to run macros, I want all those queries (and connection session) to have a particular tag refering my module/team name so that it is easy to see the usage and allocate budget to teams.

Snowflake Python module accepts ‘application’ parameter which we can use to set to our module/team name. However dbt - snowflake connector hard codes it to ‘dbt’. Is there a way we can update it so as to append my module name / overwrite default value in ‘application’ field ?
Link to DBT - Snowflake connector code

What I’ve already tried

I tried using ‘query_tag’ in profile.yml, but we really wanted to have our module/team names in Client Info for ease of filtering (as other non-dbt based teams are using same approach via JDBC/ODBC drivers).

2

Hello, any suggestions/alternatives to above problem ?

3

We also have the similar requirement to have our Application name instead of hardcoded ‘dbt’ value.

@v4mishra, did you find any solution/alternatives to achieve this?

4

Hi @v4mishra , I have raised a PR for this issue - Parametrizing application name for more flexibility by PrantikTechie · Pull Request #966 · dbt-labs/dbt-snowflake · GitHub
If this gets merged then I think the query_tag which we pass in profiles.yml that will be shown in client driver details.