Home » Solve “All projects failed to load” in GoodData

Solve “All projects failed to load” in GoodData

  • by
  • 2 min read

Here’s a blog on GoodData. They have a clever way of prepping and loading data from data warehouses. I was under the impression that reading rights would suffice for GoodData to access my BigQuery datasets, but clearly, that wasn’t the case.

In GoodData’s Data Integration Console, I got this big red error when I scheduled a process.

“ERROR: All projects failed to load.”

When I went to through GoodData’s logs, I found the following entry.

[...] Reason: Unable to query and split data for table=gd_view_event_stream_gooddata:
    Unable to query and split data for table=gd_view_event_stream_gooddata:
    Access Denied: Project [...]: User does not have bigquery.jobs.create permission in project [...]

Clearly, I hadn’t given the service account that GoodData needs the proper rights. It only had “BigQuery Data Editor”, but it should have gotten the BigQuery Job User Role too.

This (out-of-the-box) role has the bigquery.jobs.create permission and gives your service account the necessary permissions to load the data into BigQuery.

Great success!

Say thanks, ask questions or give feedback

Technologies get updated, syntax changes and honestly… I make mistakes too. If something is incorrect, incomplete or doesn’t work, let me know in the comments below and help thousands of visitors.

Leave a Reply

Your email address will not be published. Required fields are marked *