Synapse pipeline run status as an email

Godfrin, James 0 Reputation points
2023-03-15T15:36:55.1166667+00:00

Is it possible to generate a report that runs daily to send Azure Synapse pipeline run status as an email. Right now I am able to query Monitor as below to get the result:

SynapseIntegrationPipelineRuns 
| where monthofyear(Start) == monthofyear(now()) and dayofmonth(Start) == dayofmonth(now())
| sort by End desc 
| project PipelineName, RunId, Start, End, Status;
Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,036 questions
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,695 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MartinJaffer-MSFT 26,061 Reputation points
    2023-03-16T19:54:17.0566667+00:00

    @Godfrin, James Hello and welcome to Microsoft Q&A.

    I understand you want to automate email reports from Azure Monitor about Azure Synapse pipeline run status, and you already have a query which satisfies your data needs.

    Synapse itself does not send emails, the pattern is to make calls to a service which does.

    Monitor suggests these email automation options. The link includes a tutorial on using Azure Function template for Application Insight. I think you should be able to just substitute the query there with your own.

    Let me know if this was helpful or not.

    0 comments No comments