Activity log for Azure Synapse tables

Charlie Keen 20 Reputation points
2025-01-21T15:40:18.62+00:00

Hi all is there a way to have an activity/change log for tables within a SQL database on Azure Synapse? I would like to be able to see:

  • when a record got changed
  • Who changed it
  • What did it change to and from?

I've searched but cannot seem to find anything. Thanks.

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.
5,175 questions
{count} votes

Accepted answer
  1. Shikha Ghildiyal 3,500 Reputation points Microsoft Employee
    2025-01-21T16:08:25.0633333+00:00

    Hi Charlie Keen,

    Thanks for reaching out to Microsoft Q&A.

    Please refer to this document to understand how you can enable logs - https://learn.microsoft.com/en-us/azure/synapse-analytics/monitor-synapse-analytics

    You can monitor Synapse Analytics workspaces and pools directly from their Azure portal pages. On the left sidebar menu, you can access the Azure Activity log, or select Alerts, Metrics, Diagnostic settings, Logs, or Advisor recommendations from the Monitoring section.

    Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.