Does Log Analytics collect table modification(Azure SQL DB) logs?

Partha Das 286 Reputation points


Does Log Analytics collect table modification(Azure SQL DB) logs?

Lets take an example - I have a table in Azure SQL DB with diagnostic settings on. I ran simple update statement or changed any cell using SSMS.

Can these actions be logged? If yes, how can I check in Log Analytics workspace?

Please help.


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,034 questions
Azure SQL Database
{count} votes

Accepted answer
  1. TP 83,961 Reputation points


    Table/row/cell level changes are not logged using the built-in Azure SQL Database telemetry.

    If you want data changes to be logged to Log Analytics you would need to write your own custom solution. For example, enable Change Data Capture, then write a custom app that sends changes to Log Analytics workspace.

    Configure streaming export of Azure SQL Database and SQL Managed Instance diagnostic telemetry


1 additional answer

Sort by: Most helpful
  1. Andrew Blumhardt 9,771 Reputation points Microsoft Employee

    Most resources in Azure can send logs as diagnostics and metrics to a workspace. Changes to Azure resources can be found in the Azure Activity log. I would think you should see updates in the standard or activity logs.