BQ Admin but cannot access INFORMATION_SCHEMA.TABLES

Google Cloud Data Analytics
1

I have the IAM role of Bigquery Admin, yet when I try execute an INFORMATION_SCHEMA.TABLES query I get the error:

Access Denied: Table :.INFORMATION_SCHEMA.TABLES: User does not have permission to query :.INFORMATION_SCHEMA.TABLES, or perhaps it does not exist in location US.

I confirmed that the data location is the US.

It seems many similar community posts refer to IAM roles/permissions as the root cause, but, according to Google documentation, am already given all necessary permissions as a Bigquery Admin.

Any help would be greatly appreciated. Thanks.

2

If you have the role BigQuery Admin it should work. So let’s question assumptions:

  1. What is the EXACT SQL statement you are executing (redact as necessary)
  2. Prove to the readers that you have this role. You must have it at the appropriate level (Org, Project, Folder or Dataset)
  3. Prove that the Dataset lives in US region
3

Hi Kolban,

Many thanks for the reply. It turns out I had a simple typo in the project name, hence the error. Once corrected, no issues in running the query.

However, your troubleshooting suggestions were helpful in that I was able to confirm along the way how to check permissions at an org, project and dataset level!

Thanks again!

4

It’s throwing the same error to me, i am administrator of the project, but the project is outside US. In southamerica-west1.