Client does not have permission to get URL /bigque...

sanmitra

Hi,

I'm currently running bigQuery jobs from my production server - Inserting data into bq tables everyday, scheduled.

I am using the sdk - google-cloud-bigquery-1.90.0
Recently and not consistantly started facing this error -
```
<!DOCTYPE html>
<html lang=en>
<meta charset=utf-8>
<meta name=viewport content="initial-scale=1, minimum-scale=1, width=device-width">
<title>Error 403 (Forbidden)!!1</title>
<style>
*{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}
</style>
<a href=//www.google.com/><span id=logo aria-label=Google></span></a>
<p><b>403.</b> <ins>That’s an error.</ins>
<p>Your client does not have permission to get URL <code>/bigquery/v2/projects/xxxxxxxxxx/jobs</code> from this server. <ins>That’s all we know.</ins>
```

But I can see the data was updated. I have added the following roles to the service account and yet I face this issue - BigQuery.Admin, BigQuery.JobUser, BigQuery.User.

Could you help me please?
Thanks
Sanmitra

a_aleinikov

Hi @sanmitra ,

A 403 on /bigquery/v2/.../jobs often means:

Missing OAuth scope: Make sure your service account has the https://www.googleapis.com/auth/bigqueryscope (especially on VMs).
Auth issue: If using gcloud, re-run gcloud auth application-default login.
Missing project-level permission: Add Viewer or resourcemanager.projects.get on the project, not just BigQuery roles.

Check these, and the error should go away.

sanmitra

Hey a_aleinikov,
Thanks for the reply!

The thing is - it works fine but sometimes fails and returns back to working fine..
The quotas are well under check as well.

Client does not have permission to get URL /bigquery/v2/projects/xxxxxxx/jobs from this server