When users have the BigQuery Data Editor role in our project, they experience terrible performance when listing Datasets in the web UI.
Turns out it helps to assign these permissions in addition through a custom role:
- bigquery.datasets.listEffectiveTags
- bigquery.datasets.listSharedDatasetUsage
- bigquery.datasets.listTagBindings
At least one of those missing seems to slow down fetching dataset information massively (30secs before vs. ~4 secs after adding those, ~600 datasets)
Also, searching for datasets does not work by default although these users can list all datasets and all tables in them. It would make sense for search to also work. However it returns zero results unless the BigQuery Metadata Viewer role is applied.
If I am not mistaken, these details are not documented and I had to find those things out by trial and error.
LinkedIn
Twitter
