Google BigQuery Share Dataset Access - how can I know who have been given the shared access to these datasets/tables

Question

We can share individual dataset access, through this step.

https://cloud.google.com/bigquery/docs/dataset-access-controls

Select the dataset
Share the dataset

We can do this one by one. And we can even share the individual BigQuery table this way.

But how can I know who have been given the shared access to all these datasets/tables of my GCP project?

Instead of go to the each dataset and each table, check "share" link manually?

Thanks!

have you ever tried using Magnus? If so, you can easily use API Task to collect all the needed stats that exposed in PAIs only — Mikhail Berlyant

aemon4 aemon4 · Accepted Answer · 2020-07-17T09:30:59

I personally use a python function that shows that information for all datasets.

from google.cloud import bigquery
import os

client = bigquery.Client()
datasets = list(client.list_datasets())  
project = client.project
print("Datasets in project {}:".format(project))
for dataset in datasets:
    os.system('bq show --project_id {}  {}'.format(project,dataset.dataset_id))

Google BigQuery Share Dataset Access - how can I know who have been given the shared access to these datasets/tables

2 Answers