[Feature] Change BigQuery `labels` to be additive instead of "clobber" about dbt-bigquery

[davidwitk]

@dbeatty10 Given historic issues such as #893, this issue here, the discussion you mention on dbt Discourse, this seems to be a relevant issue for many community members. Even if this is not a bug and currently intended behavior, many seem to expect additive behavior, and it would make using labels much easier.

The proposed workarounds are not optimal:

• Repeated labels: This workaround is not DRY and creates potentially lots of duplication
• Post-hooks: Running so many post-hooks is not efficient and creates a lot of overhead

[dbeatty10]

Thanks for reaching out @moseleyi !

Based on the docs here, this looks like the intended behavior rather than a bug.

So I'm going to close this as "not planned".

In order to make the documentation for the labels config in dbt-bigquery more clear, I've opened this issue: dbt-labs/docs.getdbt.com#4864

[moseleyi]

Why wouldn't you plan it? Having it like it is right now, diminishes the usability of this feature.

It's expected as per the docs but surely they should be additive? They should work just like tags

[dbeatty10]

@graciegoheen and I discussed this briefly.

The current (non-additive) behavior of labels is clearly documented, so it is not a bug. But we're open to recategorizing this as a feature request to get a feel if others are interested in this as well.

At this point, it's not a priority for us, and I'm labeling this as "refinement" for us to determine at some point in the future if we'd want to adopt this or not.

In the meantime, you could take a look at what others have done as a workaround here.

[iamtodor]

I feel the current one could be related to this one #1110