Forum Discussion

sanam's avatar
sanam
New Contributor
6 years ago

Snap sql server execute

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?

2 Replies

  • dmiller's avatar
    dmiller
    Former Employee
    6 years ago
    Copy LinkReport

    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's avatar
    sanam
    New Contributor
    6 years ago
    Copy LinkReport

    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.