Azure date explorer synapse table usage statistics. Logs include DatabaseName, TableName, User that can be used for monitoring cluster's table usage
Table attributes
Attribute
Value
Resource types
microsoft.synapse/workspaces
Categories
Azure Resources
Solutions
LogManagement
Basic log
No
Ingestion-time transformation
No
Sample Queries
-
Columns
Column
Type
Description
ApplicationName
string
The name of the application that invoked the command
_BilledSize
real
The record size in bytes
CorrelationId
string
The client request ID
DatabaseName
string
Name of the database
_IsBillable
string
Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
MaxCreatedOn
datetime
Lastest extent time of the table
MinCreatedOn
datetime
Earliest extent time of the table
Principal
string
Principal that invoked the query like 'aaduser=USER_ID;TENANT'
_ResourceId
string
A unique identifier for the resource that the record is associated with
RootActivityId
string
The root activity ID
SourceSystem
string
The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics
StartedOn
datetime
The time (UTC) the table usage statistics operation started
_SubscriptionId
string
A unique identifier for the subscription that the record is associated with