Synapse Analytics Pipeline Alerts

Question

Hi,

I am trying to setup synapse pipeline alerts in Azure. I have performed the following steps.

1. I have both log analytics and synapse analytics workspaces created
2. I ran a pipeline in synapse studio just for checking the logs
3. I have added diagnostic setting in synapse workspace to push all logs to log analytics
4. I have given log analytics contributor and monitoring contributor roles to synapse managed identity in Log analytics IAM
5. Created a email action group and alert rule for Pipeline ended runs.

I am not able to see any fired alert and also not able to view PipelineIntegrationruns,TriggerRuns and ActivityRuns tables in log analytics workspace when I tried to query the logs. I could see only these below tables in the log analytics.

Answer 1

Hi Visa ,

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

I understand that you are trying to configure alert for synapse pipelines using log analytics and azure monitors. However, after all the configuration correctly done, the alert is not getting fired. Kindly let me know if that is not the correct understanding.

1. Kindly check in your diagnostics settings, you have selected all the required logs. If you miss selecting the logs that you want to capture , their related tables won't be appearing.
2. Take the query from the alert rule and run the same in the logs and see if the query is returning result or not.

Usually, after creating log analytics workspace, it takes 15-20 mins of times for populating all the tables and for alerts to be fired , it takes few mins. So, kindly revalidate if all the above steps are taken care and check if alerts got fired or not.

For more details, kindly check out this video:

How to setup email alerts with Azure Log Analytics for azure Data Factory pipeline

Hope it helps. Kindly accept the answer by clicking on Accept answer button and take the survey. Thankyou