Issue with Google Bigquery Access Denied

[Anonymous]

Hi everyone,

i've got an Issue with GoogleBigQuery. The goal is to extract data from local Excel files, move them to a CSV and insert all this to a BigQuery Table.

I've managed to create the final CSV but the upload to BigQuery fails with the following error message:

Exception in component tBigQueryOutput_1_tBQBE (FetchEmailReport)
java.lang.RuntimeException: Job failed: BigQueryError{reason=accessDenied, location=null, message=Access Denied: File gs://myfolder/my_source_csv.csv: Access Denied}
at callone_cdr_email.callonefetchemailreport_0_1.CallOneFetchEmailReport.tFileList_2Process(FetchEmailReport.java:1687)

The used service account does have the following rights, which should be sufficient?

• BigQuery-Dataeditor
• BigQuery-User
• Storage-Object-Administrator
• Storage-Object-Creator

Interesting is also, that a 

biquery_bulk.txt

was created in the cloud storage bucket. 

Any ideas what i am missing here?

[Anonymous · Accepted solution]

The "problem" was solved. I simply just didn't gave enough time for Google after changing the access rights. 2 minutes later everything worked.

Thanks anyway for reading 🙂