[CT-893] [CT-796] [Feature] enable query tagging for dbt tests on snowflake

[matt-winkler]

Is this your first time opening an issue?

• I have read the expectations for open source contributors

Describe the Feature

query tagging is supported on models and snapshots in snowflake projects, but not on tests. Since tests also run queries against the warehouse, enabling tagging will allow users to have a fuller picture of dbt driven workloads.

Describe alternatives you've considered

• pre / post hooks to set markers for test runs
• reliance on user / environment naming conventions to separate workload data

Who will this benefit?

dbt + snowflake users

Are you interested in contributing this feature?

yes

Anything else?

here is how we manage this for snapshots.

[jameszhenginsta]

Hi,
My company is using DBT and planning to write data quality tests against Snowflake using dbt test. We have jobs that calculate the cost per query and attribute the cost appropriately. However, they have to be tagged. The tests are like any query and can run for very long so it is important to be able to tag and attribute the costs of test.

Thanks!

[jtcohen6]

@matt-winkler Thanks for opening! The request feels totally reasonable, as does the implementation you've suggested: "wrapping" the default 'test' materialization, same as we do for seeds and snapshots.