Information_schema.table_storage at dataset level

[shubham21feb]

Do we have Information_schema.table_storage table at Dataset level? not getting excess to execute the query at  region level. 

Dataset level query below

SELECT *

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

[NorieRam]

Hi @shubham21feb,

Welcome to Google Cloud Community!

Currently, INFORMATION_SCHEMA.TABLE_STORAGE is not available at the dataset level. It is only accessible at the region level. Therefore, your dataset-level query will not work. If you're unable to access it at the region level, it's likely due to insufficient permissions. You may need to contact your BigQuery administrator and request the "BigQuery Data Viewer" or "BigQuery User" role at the region level where your datasets reside.

I hope the above information is helpful.

[shubham21feb]

Thanks @NorieRam