Notification email fail/not started pipeline Synapse

MG 5 Reputation points
2024-06-27T09:18:56.04+00:00

I would like to set up a notification (email) for a pipeline in Synapse to be sent if it fails or if it does not start. How do I do this? I have already created an Azure alert, but it only triggers if the pipeline encounters an error, not if it does not start.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,621 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 30,716 Reputation points MVP
    2024-06-27T12:15:59.9233333+00:00

    Based on my knowledge, there is no in built way to set up an alert in case if the pipeline didnt get triggered (even though it was scheduled for)

    You can set up alerts for success or failure.

    In case if you want to receive alerts in case of pipeline not getting triggered, you would have to have a custom logic at the destination end

    Eg : lets say your sink gets refreshed at 7pm everyday, you can add a logic at sink end to check the status of refresh and if refresh is not done; then validate the pipeline run history and notify