[ADAP-502] [Regression] 400 PATCH Policy tags can only be attached to a leaf field.

[steve-marmalade]

Is this a regression in a recent version of dbt-bigquery?

• I believe this is a regression in dbt-bigquery functionality
• I have searched the existing issues, and I could not find an existing issue for this regression

Current Behavior

After upgrading to DBT 1.5, several models are failing with the error 400 PATCH Policy tags can only be attached to a leaf field. It's not happening to every model, but there's also nothing obvious about them that indicates what the issue is.

Expected/Previous Behavior

These models ran successfully

Steps To Reproduce

Unfortunately, I don't have a toy example to reproduce this issue.

Relevant log output

16:26:39  Completed with 4 errors and 0 warnings:
16:26:39  
16:26:39  400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/my-project/datasets/my-dataset/tables/my-table?prettyPrint=false: Policy tags can only be attached to a leaf field.

Environment

- OS: Ubuntu 22.04.2 LTS (via Github Actions)
- Python: 3.10.6
- dbt-core (working version): 1.4.6
- dbt-bigquery (working version): 1.4.0
- dbt-core (regression version): 1.5.0
- dbt-bigquery (regression version): 1.5.0

Installed via pipx install dbt-bigquery --include-deps

Additional Context

In my search, this issue seems like it might be related #605

[dbeatty10]

Thanks for reporting this @steve-marmalade !

I haven't gotten a chance to dive in yet, but this looks like a similar/same error message as in #687

[patricker]

I had the exact same issue. I initially reported in the dbt-core repo, so didn't see yours.
#687

[dbeatty10]

I'm going to close this one in favor of #687

If they end up being unique from each other, then we can re-open it.

Thank you both @steve-marmalade and @patricker 🙏

[steve-marmalade]

Thanks @patricker and @dbeatty10 🙏