Forum Discussion

aditya_sharma's avatar
aditya_sharma
New Contributor III
9 years ago

RedShift Bulk upsert execute irrespective of data coming or not after router snap

Hi, I have a parent child pipelines in which I am trying to use multiple Bulk Upsert snaps, as my target tables has different number of columns making unique/primary keys, some tables has only 1 co...
lzapart's avatar
lzapart
New Contributor III
9 years ago

Hi,

I’m not sure if you solved this yet but if you did please share your solution.

If you still have this issue, couldn’t you add a record count step and then filter snap for the routes? That way you only proceed to the BulkUpsert step when you have records in each route and avoid a failure. This should also skip your dynamic parameter error in your step.