Debugging Big Query Integration

  • 3 February 2021
  • 2 replies

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.


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

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 - 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.