3

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.

    enter image description here

  2. Account1 can query the external table data successfully.

    enter image description here

  3. Grant Account2 below roles on the project.

    enter image description here

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

    enter image description here

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

James Z
  • 12,209
  • 10
  • 24
  • 44
Qiuyun Yu
  • 33
  • 1
  • 3

1 Answers1

6

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.

Hristo Hristov
  • 101
  • 1
  • Thank you Hristofor your quick reply. After grant second user permission on bucket, the issue is resolved. Thanks again. :) – Qiuyun Yu Oct 12 '20 at 06:37
  • One more question, when I try to connect to this table in Power BI desktop via second user account, no table displays, may I know if I need grant any other permissions? Or how to resolve this? Thanks – Qiuyun Yu Oct 12 '20 at 10:15