Provide READ access to only BigQuery INFORMATION_SCHEMA objects for the Service Account

[keerthi17v]

I would like to provide READ access to only BigQuery INFORMATION_SCHEMA objects for the service account. May i know the instruction please what needs to be done?

[mdideles · Accepted solution]

You can give the role to the SA at the project, folder or the organization level, depending on the scope.

• roles/bigquery.metadataViewer

[shubham21feb]

Hi @mdideles ,

Do we have Information_schema.table_storage table at Dataset level? Like below

SELECT *

FROM `project-level.Dataset-level.INFORMATION_SCHEMA.TABLE_STORAGE`;

[mdideles]

There's none right, from this link you can refer. Introduction to INFORMATION_SCHEMA  |  BigQuery  |  Google Cloud

I think, you can get the dataset level details if you summarize by TABLE_SCHEMA (dataset_id).

[shubham21feb]

Hi @mdideles  I am not getting access on region-us level access on table_storage. Hence try to find the dataset level of table_storage? I dont think we have dataset level table of table_storage