SynapseSqlPoolExecRequests

Information about SQL requests or queries 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.
ClassifierName string The classifier name of the execution requests.
ClientCorrelationId string The correlation set by client/user.
Command string The SQL command of the execution requests.
DatabaseId string The databaseId 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.
ExplainOutput string The output explain of the execution requests.
Importance string The importance 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
Label string The label of the execution requests.
LogicalServerName string The logical server name of the SQL DW.
OperationName string The operation associated with log record.
RequestId string The requestId of the execution requests.
ResourceAllocationPercent string The resource allocation percent of the execution requests.
ResourceClass string The resource class 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
ResultCacheHit string The result cache hit of the execution requests.
RootQueryId string The rootQueryId of the execution requests.
ScopeDepth int The scope depth of the execution requests.
SessionId string The Session ID of the SQL pool instance.
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.
StatementType string The statement type of the execution requests.
Status string The status of the execution requests.
SubmitTime datetime The submitTime (UTC) 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.
Type string The name of the table