BigQuery authorized dataset

[roypruettDex]

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

Currently, dbt has the capability to configure authorized views via the "grant_access_to" config in BigQuery. It would be a great feature for dbt to have the ability to create an authorized dataset.

Describe alternatives you've considered

It is possible to create a plethora of authorized views for each object in the downstream dataset, but this would get messy very quickly in that there would be a multitude more authorized views configured than what could be authorized datasets. Per BigQuery documentation a dataset's access control list can have up to 2,500 total authorized resources. We would surely not run into the limit issue if authorized datasets can be configured rather than authorized views.

Who will this benefit?

Any and all who use BigQuery as their data warehouse who currently or wish to leverage authorized views

Are you interested in contributing this feature?

not sure i can be of help with writing code

Anything else?

No response

[dbeatty10]

Thanks for reaching out @roypruettDex !

This looks the same as dbt-labs/dbt-adapters#594, so I'm going to close this one as a duplicate. Don't hesitate to let me know if this one seems distinct / unique and we can take a look at re-opening it.