The problem I’m having
When the query is being hit through dbt, at snowflake end the application name is being displayed as dbt as it is hardcoded in the code.
The context of why I’m trying to do this
To resolve this and provide more flexibility to users, we can parametrize it and whatever query tag the user passes, we can add that as application name
What I’ve already tried
I have already raised a PR for it - Parametrizing application name for more flexibility by PrantikTechie · Pull Request #966 · dbt-labs/dbt-snowflake · GitHub
Some example code or error messages
handle = snowflake.connector.connect(
account=creds.account,
user=creds.user,
database=creds.database,
schema=creds.schema,
warehouse=creds.warehouse,
role=creds.role,
autocommit=True,
client_session_keep_alive=creds.client_session_keep_alive,
application="dbt",
insecure_mode=creds.insecure_mode,
session_parameters=session_parameters,
**creds.auth_args(),
)