Issue with Google Bigquery Access Denied

Anonymous — Sat, 16 Nov 2024 06:51:42 GMT

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?

Re: Issue with Google Bigquery Access Denied

Anonymous — Mon, 14 Jan 2019 17:28:12 GMT

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 🙂

topic Issue with Google Bigquery Access Denied in Talend Studio

Issue with Google Bigquery Access Denied

Re: Issue with Google Bigquery Access Denied