How to create email notification alerts using Data Factory instead of Logic Apps

Hemanath Goud Kandula 1 Reputation point
2022-09-29T09:37:41.233+00:00

Hi,

I have been using the Azure Data Factory for a long time. I have created different data pipelines also using the Data Factory. I have used Logic Apps for sending the Email notifications like Status checks, Error messages whenever the pipeline is failed.

I know that we can also send the Email notifications using directly using Data Factory but I don't know how to send it.
Can anyone help me with how I can send Email notifications like status checks, Error messages directly using the Data Factory?

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,800 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,535 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 30,676 Reputation points Microsoft Employee
    2022-09-30T09:31:33.64+00:00

    Hi @Hemanath Goud Kandula ,

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

    As I understand your ask, you are trying to trigger an email using ADF pipelines without using Logic app.
    You can go for one of the below suggested options:

    You can create an Alerts in Azure Data Factory (ADF) Monitor section under Alerts and Metrics option.

    • Using Alert in ADF, you can get metrics like : PipelineSucceededRuns (The total number of pipeline runs that succeeded within a certain time window) , ActivityFailedRuns(The total number of activity runs that failed within a certain time window), PipelineFailedRuns(The total number of pipeline runs that failed within a certain time window) etc.
    • However, you can't customize the metrics you want to fetch or format of the mail you want to have like we can do using Logic apps. Also, as per your ask you want to get error message, it is not possible with alerts.
    • Learn more about creating alerts in Azure Data Factory.
      Kindly checkout this video for more details.
      Additional resources: Use Alerts to send out Email in ADF

    You can Send notifications to a Microsoft Teams channel from an Azure Data Factory

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments