SynapseSqlPoolRequestSteps

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.
Type	string	The name of the table