Skip to content

Email reports

We have set up a pipeline in synapse to automate the report generation-and sending.

Architecture

There are two primary components. 1. A pipeline in Synapse that is configured to run on a schedule.

The pipeline first run a Synapse Notebook to generate the HTML-reports. 
The reports are written to a Blob Storage.
Subsequently, the pipeline triggers a LogicApp to send an email with the reports as attachment.

  1. A LogicApp (ngtt-mailreport)

    The LogicApp consists of 3 steps. 1. Receiving a trigger (from the pipeline) with optional dynamic input (such as report filename and message content) 2. Fetching the report from Blob Storage 3. Inserting the report (and other optional input) as an attachment, and sending the report from a shared mailbox to the configured recipients.

Required permissions

In order to perform desired operations, the following permissions are required. * The managed identity of the Synapse Workspace: * "Read"-access to location(s) in Atlas which the notebook will read from. * "Contributor" on the LogicApp. * "Storage Blob Data Contributor" permissions on the configured blob storage. * The managed identity of the LogicApp: * "Storage Blob Data Contributor" permissions on the configured blob storage.

The Shared Mailbox needs to be set up and configured through Service Desk by making a request.