Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dataflow (gen1) fails after Join operation

Hi everyone,   I pull 7 tables from our Postgres DB into a dataflow. I was able to refresh it just fine, but after resuming my ETL process, and merging 'Orders' and 'Orderline' table to get a flat ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    In case anyone stumbles on this post, I got around by having another admin of the workspace reconfigure the credentials. Apparently the connection to a google sheet was the culprit.

     

    It has been working correctly for the last two days, fingers cross y does not randomly break.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mohitkumawat ,

 

Thanks for your assistance.

 

When you say dataflow settings, I cannot really see any load options here:

 

If you are referring to this 'enable load' then I can confirm it is now off on all tables but now the dataflow won't validate

 

 

 

 

Am I missing something?

 

Also are you suggesting that before every merge I create a reference table and merge those instead?

Thanks,

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    In case anyone stumbles on this post, I got around by having another admin of the workspace reconfigure the credentials. Apparently the connection to a google sheet was the culprit.

     

    It has been working correctly for the last two days, fingers cross y does not randomly break.