SynapseDXCommand

Azure data explorer synapse command execution summary. Logs include DatabaseName, State, Duration that can be used for monitoring the commands which were invoked on the cluster

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
Category string The log category for these events will be 'Command'
CommandType string Command type. like 'DatabasesShow'
CorrelationId string The client request ID
DatabaseName string The name of the database the command ran on
Duration string Command duration as a string like '00:00:00.0156250'
FailureReason string The reason for the failure
_IsBillable string Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
LastUpdatedOn datetime The last time this command was updated
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
ResourceUtilization dynamic Resurce consumption for the exuected command
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) when this command started
State string The state the command ended with, like 'Completed'
_SubscriptionId string A unique identifier for the subscription that the record is associated with
TenantId string The Log Analytics workspace ID
Text string Text of the invoked command
TimeGenerated datetime The time (UTC) when this event was generated
TotalCPU string Total CPU runtime across cluster nodes
Type string The name of the table
User string User that invoked the query
WorkloadGroup string Workload are a means of resource governance for incoming requests to the cluster