[CT-2587] [Feature] Support Query Tagging in Base Materializations

[trouze]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Would like to continue a discussion happening over on dbt-redshift relating to the addition of query tagging on that adapter. As other adapters are also adding this feature, I think it makes sense to plug this into dbt-core materializations and have each adapter implement macros specific to how their database implements the query tagging functionality.

This is related to discussions happening around adding this functionality to dbt-bigquery and dbt-redshift. The motivation for this is to bring what is becoming a more common feature across databases into core, limiting the repetition of this logic across adapters as discussed here.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

Yes

Anything else?

No response

[trouze]

I've added a basic vision for what this might look like. I'm not entirely sure how to handle when the query tagging concept isn't implemented within a specific adapter, especially since Postgres does not support this so we basically want to pass over and log the fact that query tagging isn't supported (or hasn't been implemented yet) for your current adapter.

[jtcohen6]

@trouze Thanks for opening up the issue, and the PR!

I'm glad to see some logic from dbt-snowflake making its way upstream into dbt-core, now that Redshift & BigQuery could both support something similar-enough. I haven't gone deep on every linked issue/PR, but I'm broadly supportive of keeping the interface consistent across the board, and it seems like we have a real chance to do that here.