Variable/Parameter Value
I have a parent pipeline followed by 5 different child pipeline. One of the child pipeline dynamically generates a variable value. How can i pass the value generated in that child pipeline during run...
Forum Discussion
I’ll reply to my own post. This error was due to timeout between SnapLogic cloudplex and on our AWS PostgreSQL instance. Adding Sort snaps in front of all my insert and update SQL snaps resolved the issue for me. I don’t quite fully understand the reasoning, but works.
Hi Davis,
I didn’t that issue but I was limited to send script in execute to only 50… something index out of bounds…
The SQL script that I was generating is upsert using the ON CONFLICT DO UPDATE… but the table have so… so… many columns, I was wondering were you able to do a bulk load using csv so that no need to declare the columns… or do you have a template that will set the columns during runtime… what is the format of the schema table ?? is it like declaring a variable in SQL? I’m kinda newbie with postgres
I have this topic opened any suggestion/insights?
Thanks,
EmEm
