How to send a mail notification for a failed pipeline in Azure Synapse Analytics?

Question

How can I send a notification email to a specific email address without using a logic app when one of my Synapse Analytics pipelines fails?

I would like to include the error message in the email notification.

Answer 1

Hi @Aditya Singh

Welcome to Microsoft Q&A platform and thanks for posting your question here.

Azure Synapse Analytics does not have a built-in option to send email alerts for pipeline failures because it is designed to be a scalable and flexible data analytics service that can handle a wide range of data processing scenarios.

Instead of providing a specific email alert feature, Azure Synapse Analytics allows you to integrate with other Azure services, such as Azure Logic Apps and Azure Functions, to create custom email notifications that meet your specific requirements. This approach gives you more flexibility and control over how you want to handle pipeline failures and other events in your data processing workflows

Reference
https://learn.microsoft.com/en-us/azure/data-factory/how-to-send-email

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Hey,

One can send the email notification of pipeline failures via alerts but that wont contain the failure message.

In case if you want to send failure error message you need to have a custom email notification way either via logic app or Azure function etc.

There can be another custom way to get the pipeline details via REST API and send email but anyhow they need custom logics/offerings

Answer 3

Hello @Aditya Singh

To send a notification email to a specific email address when one of your Synapse Analytics pipelines fails, you can use the Send Email activity in your pipeline. You can configure the activity to send an email to a specific email address and include the error message in the email notification.

Here are the steps to configure the Send Email activity:

1. In your Synapse Analytics workspace, open the pipeline that you want to configure to send email notifications.
2. Drag and drop the Send Email activity from the General tab of the Activities pane onto the pipeline canvas.
3. Configure the Send Email activity by specifying the following properties:

• Name: Enter a name for the activity.
• To: Enter the email address of the recipient.
• Subject: Enter the subject of the email.
• Body: Enter the body of the email. You can use dynamic content to include the error message in the email notification. For example, you can use the expression @activity('Copy1').error.message to include the error message from the previous activity in the pipeline.

4. Save and publish the pipeline. With this configuration, the "Send Email" activity will send an email notification to the specified email address when the pipeline fails, and include the error message in the email body.

I hope this helps.