Information about request steps that compose a given SQL request or query in an Azure Synapse dedicated SQL pool.
Table attributes
Attribute
Value
Resource types
microsoft.synapse/workspaces
Categories
Azure Resources
Solutions
LogManagement
Basic log
Yes
Ingestion-time transformation
Yes
Sample Queries
-
Columns
Column
Type
Description
_BilledSize
real
The record size in bytes
Category
string
The category of the log.
Command
string
The SQL command of the execution requests.
DistributionType
string
The distribution type of the execution requests.
EndCompileTime
datetime
The end compile time (UTC) of the execution requests.
EndTime
datetime
The end time (UTC) for the execution requests.
ErrorId
string
The errorId of the execution requests.
_IsBillable
string
Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
LocationType
string
The location type of the execution requests.
LogicalServerName
string
The logical server name of the SQL DW.
OperationName
string
The operation associated with log record.
OperationType
string
The operation type of the execution requests.
RequestId
string
The requestId of the execution requests.
ResourceGroup
string
The azure resourceGroup of the SQL DW.
_ResourceId
string
A unique identifier for the resource that the record is associated with
RowCount
int
The row count of the execution requests.
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
StartTime
datetime
The startTime (UTC) of the execution requests.
Status
string
The status of the execution requests.
StepIndex
int
The step index of the execution requests.
_SubscriptionId
string
A unique identifier for the subscription that the record is associated with
TenantId
string
The Log Analytics workspace ID
TimeGenerated
datetime
The timestamp (UTC) of when the log was generated.