How to setup email alerts with Azure Log Analytics | Data Factory pipeline failures

This video will talk about how to setup alert in ADF so that you get an email notification when ADF pipelines failed. Azure Monitor Kusto Query Language used during demo: let pipelines = ADFPipelineRun | where Status == 'Failed' and Category == "PipelineRuns"; let activities = ADFActivityRun | where Category == "ActivityRuns" and Status == "Failed" and ActivityType != "ExecutePipeline" and ActivityType != "IfCondition" and ActivityType != "ForEach" ; pipelines | join kind = inner activities on $left.RunId == $right.PipelineRunId |project DataFactory=substring(tostring(split(ResourceId, "/", 8)), 2, strlen(tostring(split(ResourceId, "/", 8)))-4), TimeGenerated, PipelineName, ActivityName, RunId, Hash=hash_sha256(strcat(PipelineName,Parameters)), Parameters, ErrorMessage, FailureType, Start , End , Status |order by TimeGenerated desc Useful links: https://docs.microsoft.com/en-us/azur... https://azure.microsoft.com/en-us/blo...