SynapseSqlPoolSqlRequests

Information about query distributions of the steps of SQL requests/queries in an Azure Synapse dedicated SQL pool.

Categories

  • Azure Resources

Solutions

  • LogManagement

Resource types

  • Synapse Workspaces

Columns

Column Type Description
Category string The category of the log.
Command string The command of the SQL requests.
DistributionId int The distribution id of the SQL requests.
EndTime datetime The end time (UTC) for the SQL requests.
ErrorId string The error id of the SQL requests.
LogicalServerName string The logical server name of the SQL DW.
OperationName string The operation associated with log record.
PdwNodeId int The PdwNodeId of the SQL requests.
RequestId string The request Id of the SQL 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 SQL requests.
SourceSystem string
SpId int The sp id of the SQL requests.
StartTime datetime The startTime (UTC) of the SQL requests.
Status string The Status of the SQL requests.
_SubscriptionId string A unique identifier for the subscription that the record is associated with
TenantId string
TimeGenerated datetime The timestamp (UTC) of when the log was generated.
Type string The name of the table