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

Question

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

Answer 1

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

I was good

Answer 2

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?