A companion code-snippet for the 2023 Coalesce talk How dbt Labs tunes model performance and optimizes cloud data platform costs with dbt. An example of overriding the default behavior of dbt-snowflake set_query_tag macro to enable 1:1 mapping between dbt invocations and Snowflake query IDs.
Create a file called set_query_tag.sql in the macro directory of your dbt project. Use the example and customize as needed.