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 |