Query table in Google BigQuery has error "Access Denied: BigQuery BigQuery: Permission denied while globbing file pattern."

Question

I'm new with Google BigQuery. Please forgive me if my question is a little simple.

Let me clarify the background of the issue:

1. Account1 create a bucket (Multi-region) and external table.

   

2. Account1 can query the external table data successfully.

   

3. Grant Account2 below roles on the project.

   

4. Account2 log in BigQuery can see the table, but can't query data, with below error.

   

I have done some research and enable BigQuery API, issue still occurs.

Answer 1

As you are reading data from a bucket, you should also give the second user access to read the data from the given bucket. Click on the bucket and from the menu select "Edit bucket permissions", then click "Add member" and grant the second user the "Storage object viewer" role. Alternatively you can use the IAM and grant this role across the whole project and thus granting read access to all buckets.