Big Query error when using python to query

1,022 views
Skip to first unread message

Troy Estlund

unread,
Jun 17, 2022, 2:21:03 PM6/17/22
to Google Cloud Developers
Hi,

The error that I am getting from BigQuery is:
User does not have bigquery.jobs.create permission in project

A person at my company created the json key and provided it to me.  
What permissions error did they make when the account was created?   Can they add the permissions in now or will a new json authentication key be required to be created?

Thanks,
Troy

Alejandro Lorea Sanchez

unread,
Jun 21, 2022, 4:15:11 PM6/21/22
to Google Cloud Developers

You don’t need to receive another file, you just need to ask the person who controls access to check if you have the correct permissions, if the environment variable is correctly set up, and verify this once all is done. You can check more in Getting started with authentication and Authenticating with a service account key file.

However, there is the possibility that this message is caused by other means. First, check you have all the required permissions. Verify you are not using public datasets, or similar stuff that might need some extra steps. If the service account is correctly set up, you can try creating a new one, as seen in that question, although in this case you might need to update the json key. And finally, check you are using the correct type of permission.

You can check all the permissions in the Understanding Roles documentation.
Reply all
Reply to author
Forward
0 new messages