Querying INFORMATION_SCHEMA.TABLE_STORAGE in BigQuery gives an access denied error

Hi @pratzz

Welcome back to Google Cloud Community.

Based on the error message it indicates that you do not have permission access with the TABLE_STORAGE view in your project which is part of INFORMATION_SCHEMA dataset.

The default settings for the permission to have access are the owner and project editors.

You may grant additional users and groups to access this data set by granting them roles via IAM.

You may use this reference to help you.
https://cloud.google.com/bigquery/docs/control-access-to-resources-iam?_ga=2.143013493.-1392753435.1676655686

https://cloud.google.com/iam/docs/granting-changing-revoking-access?_ga=2.143013493.-1392753435.1676655686