Data Engineering
Access Permissions for BigQuery INFORMATION_SCHEMA
→ 日本語版を読むI often use INFORMATION_SCHEMA views to retrieve table and column information for use in table creation and similar tasks, but I did not know that permissions are required to access INFORMATION_SCHEMA views.
Without the proper permissions, a SELECT will result in the following error:
Access Denied: Table xxxxxxx:region-us.INFORMATION_SCHEMA.TABLES: User does not have permission to query table xxxxxxx:region-us.INFORMATION_SCHEMA.TABLES, or perhaps it does not exist in location US.
To query the TABLES view, assign one of the following roles:
- roles/bigquery.admin
- roles/bigquery.dataViewer
- roles/bigquery.metadataViewer