Permissions Error Exporting a table from Google BigQuery to Google Cloud Storage

9
votes

Getting the following error as of 2017-07-08 when exporting a table to Cloud Storage.

Access Denied: BigQuery BigQuery: Permission denied while writing data

Working fine before that date, haven't changed anything in the project, big query or cloud storage.

JobId: alert-basis-89415:bquijob_6adfd86e_15d2de5ce1b

4
google-bigquerygoogle-cloud-storage
Did you manage to solve this issue? - Ary Jazz
See my answer :) - Breandán

4 Answers

0
votes

It appears the user running the job doesn't have storage.objects.create permission to the GCS bucket - perhaps something changed with bucket permissions? Is this still recurring, can you explicitly add that user to the bucket ACLs?

0
votes

Look up the service account's e-mail address, and add the account to the bucket ACL as a writer and file reader: 

gsutil acl ch -u [email protected]:W gs://bucket
gsutil acl ch -u [email protected]:R gs://bucket/1.csv
gsutil acl ch -u [email protected]:R gs://bucket/2.csv
0
votes

I was getting a similar error. It was because I was using a bucket in region different from the BQ dataset, and a incorrect bucket URL. After I ensured following two

  • I double checked and fixed specified bucket URL is correct
  • I created bucket in same region that the data resides
-4
votes

It was a problem on Google's end. I found a topic in Google groups (can't seem to find it now) where you could supply your details and they applied a hotfix for those accounts before rolling it out proper.