CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquery
Juan Lozano
Juan Lozano

Reputation: 667

Google cloud error when reading a table via a notebook on GCP

Hi I have a google email account that I use the get into a GCP project, I am trying to read a BigQuery table via a Notebook but when I try to read this table via the notebook I see this error;

Access Denied: Table project-name:data_warehouse_us.partnerize_data_clicks: User does not have permission to query table project-name:data_warehouse_us.partnerize_data_clicks. [accessDenied]
Traceback:

I go into the IAM settings, and I see the email account I use to access it and it has these 3 roles, `"BigQuery Admin" "BigQuery Data Owner" "BigQuery Job User" do I need to add another role to be able to read/write/delete access to the tables? or is there another place I need to go to be able to fix this error?

thanks

Upvotes: 1

Views: 436

Answers (1)

Ricco D
Ricco D

Reputation: 7277

Posting as answer confirmed by @JuanLozano. Notebooks uses a service account to authorize requests. While you may set those permission to your email account, you still have to set those permission to the service account that your Notebook uses.

Check the defined service account to the Notebook, and then add the necessary permissions too it.

Upvotes: 2

Related Questions