[ADAP-545] [Feature] Add support for Authrorized Datasets and dataset-level grants

[akerone]

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-bigquery functionality, rather than a Big Idea better suited to a discussion

Describe the feature

The ability to configure Authorized Datasets in dbt-project.yml, similarly to Authorized Views. For example, a +grant_access_to: where +schema: is also present at the same level could authorize the whole dataset rather than all individual views.

The same goes for direct grants.

Describe alternatives you've considered

dbt currently achieves the same result although, in our opinion, a less user-friendly way. Giving permissions to every separate model becomes hell when it's time to revoke any of them.

Who will this benefit?

Every single BQ admin who's in any way concerned by security. It also indirectly solves dbt-labs/dbt-bigquery#126.

Are you interested in contributing this feature?

No response

Anything else?

No response

[dbeatty10]

Thanks for opening this feature request @akerone !

It sounds like making the revoke process easier is your primary goal?

Did you consider an alternative using grant config inheritance in your dbt_project.yml similar to the following (using BigQuery-specific syntax)?

dbt_project.yml

models:
  project_name_here:
    folder_name_containing_your_dataset_models:
      +grants:
            roles/bigquery.dataViewer: ['user:[email protected]', 'user:[email protected]']

[akerone]

Hi, sorry for the late response.

Giving read permission directly to the tables is not an option, as we want to grant read access only to the authorized views.

[acovaci]

👍🏻 It makes a lot of sense to grant dataset-level permissions (which can even be executed via SQL), and I ran into needing this too.

For example, you have a bunch of tables in your dataset. You want the user to see only specific ones. You need to grant:

• bigquery.tables.get on the tables
• bigquery.tables.list on the dataset

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.