how to get exception from synapse notebook in pipeline activity

Question

Hi Team, I ran a notebook from the pipeline and it has failed with exception in the notebook but pipeline activity has showing succeeded. How can i get the error details of the notebook from pipeline and will send the error notification through email. Thanks, Satya

Answer 1

Hi Veera Satya Teja Mummidi, Thank you for posting query in Microsoft Q&A Platform.

You can consider using mssparkutils.notebook.exit() function, to exit notebook with exception details. And then in pipeline, in activity output, you will see the error details. Based on exit value in pipeline, you can consider implementation of trigger email.> Kindly consider check below video to understand more about this.> exit() function of notebook module in MSSparkUtils package in Azure Synapse Analytics

Please consider checking below sample code for notebook.

Hope this helps. Please let me know if any further queries.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.