How do I get a notification for Azure Synapse Workspace Publishes

Question

We have an Azure Synapse Workspace in live mode. We do have a DevOps release pipeline that is used to deploy changes to the pipelines/artifacts. The aforementioned Workspace that is used as the target workspace for release deployments is kept in live mode.

We want to get alert if changes are made to the workspace outside of our DevOps process. Everytime a direct publish is made in the workspace a notification pops up, however that notification only persists within an individual session. How can we convert that notification into an email notification or at least access a record of the last publish date of the workspace (to compare against deployment date to confirm if additional changes are made).

Alternatively is there an Azure Monitor/Alert setup that can be used to catch these publishes. Apparently it doesn't seem to show up in the activity log, and the alert signals don't call out publishes. Workspace create/updates apparently can trigger alerts however when I publish an artifact change that doesn't seem to trigger any alerts.

Additionally is there a way to configure the Synapse workspace so that a workspace in live mode can have the publish button disabled so that only releases from Devops can be pushed to production? I think this is an option in the other mode, but not in live mode.

Answer 1

Hi Nicholas Nguyen,

Thanks for reaching out to Microsoft Q&A.

synapse workspace’s publish activities and changes can be challenging to monitor directly, but you can try strategies to help you track and manage publishes more effectively.

The synapse workspace activity logs generally capture significant changes, but detailed publish activities might not be included. For more detailed monitoring, you might need to integrate with azure monitor or set up custom logging.

If direct publish activities are not visible in standard logs, consider implementing a custom logging approach. You can create azure functions or logic apps that monitor specific conditions or events and then send notifications.

Set up a system to capture and log publish events, either through custom scripts or azure functions. For instance, you might create an automated process that logs each publish action into a database or a monitoring system. Use this logged data to send email notifications or alerts based on publish actions.

Unfortunately, in synapse analytics, the option to disable the publish button directly in live mode is not available

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.