Cloudworks Integration "There was an internal server error" for BigQuery Data Source option

Hi experts,

 

I was trying to export Anaplan data to BigQuery via Cloudworks. I have established a connection but when I am trying to set up the integration, I keep encountering the issue of "There was an internal server error" under the Data Source option. Can anyone provide any advice on how to resolve this?

ColinNgSH_1-1663603785742.png

 

 

Answers

  • I encountered a similar error before and it was due to the connection setup, even though the connection setup was successful. Make sure the dataset in the BigQuery connection setup is only the dataset and does not include the project in there as well. 

     

    For example:

    Correct - table_abc

    Incorrect - project-123.table_abc

  • Matt - Thank you! This was exactly the issue that had me dead in the water for a full day.