Snap sql server execute

[sanam]

Hi Team,

when i write two statement in sql server execute snap. e.g first is truncate table and then load table it does not error out if the second sql statement fails.

Can you please let ,me know if there is any way to make the snap fail if any sql statements have errors?

[dmiller]

Welcome back, @sanam

A couple of suggestions have been proposed around the virtual water cooler today 🙂

• Have one execution per Snap, as this makes troubleshooting easier. It also makes the pipeline easier to read if someone new has to pick it up.
• drop these into a sub-pipeline, where they can still be executed as individual Snaps, but the errors could be handled separately. This would have the advantage of being still just a single step in the parent pipeline.

[sanam]

it will be great if I could put two sqls in one execute and handle the errors.
for simple steps it really make my pipeline long.

Thankyou for the prompt reply.