Forum Discussion
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
I haven’t used the bulk load feature at all. When I stage my data I just use a mapper snap and then an insert. I suppose you could dynamically set all the column names, but it isn’t something I’ve actually done in SnapLogic.
Related Content
- 6 months ago
- 12 months ago
- 11 months ago
- 4 years ago