Solved

Debugging Big Query Integration

  • 3 February 2021
  • 2 replies
  • 69 views

I’m trying to link Good Data with Google Big Query. I can connect to Big Query and create the LDM and publish, but when I try to load the data  I’m seeing the following errors in the log during the “download and integrate” step:

Project "xxx123" was not integrated Data distribution worker failed. Reason: All projects failed to load.

I’m pretty sure I’m missing something silly.

icon

Best answer by Moises Morales 3 February 2021, 21:02

We found that the ETL is failing due to a wrongly formatted date field. Please double-check this on your source data and also make sure it meets the criteria outlined in our Platform Limits.

View original

2 replies

Userlevel 1

We found that the ETL is failing due to a wrongly formatted date field. Please double-check this on your source data and also make sure it meets the criteria outlined in our Platform Limits.

Thanks @Moises Morales also found that the Big Query timestamp format wasn’t working without some tweaks. I was following this - https://help.gooddata.com/doc/en/building-on-gooddata-platform/data-preparation-and-distribution/direct-data-distribution-from-data-warehouses-and-object-storage-services/gooddata-bigquery-integration-details. Not sure if its supposed to be necessary, but once I transformed the timestamp to a date type I was able to get it working.

Reply