Synapse pipeline run status as an email

Question

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;

Answer 1

@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.