Log Analytics tables for microsoft.synapse/workspaces

Table Categories Solutions Supports basic log plan Queries
AzureActivity

Entries from the Azure Activity log that provides insight into any subscription-level or management group level events that have occurred in Azure.

resources, audit, security LogManagement No Yes
AzureMetrics

Metric data emitted by Azure services that measure their health and performance.

resources LogManagement Yes Yes
SQLSecurityAuditEvents

Azure Synapse SQL Audit Log.

resources LogManagement No -
SynapseBigDataPoolApplicationsEnded

Information about ended Apache Spark applications.

resources LogManagement No -
SynapseBuiltinSqlPoolRequestsEnded

Ended Azure Synapse built-in serverless SQL requests.

resources LogManagement No -
SynapseDXCommand

Azure data explorer synapse command execution summary. Logs include DatabaseName, State, Duration that can be used for monitoring the commands which were invoked on the cluster

resources LogManagement No -
SynapseDXFailedIngestion

Failed ingestion operations logs provide detailed information about failed ingest operations. Logs include data source details, as well as error code and failure status (transient or permanent), that can be used for tracking the process of data source ingestion. Users can identify usage errors (permanent bad requests) and handle retries of transient failures. Ingestion logs are supported for queued ingestion to the ingestion endpoint using SDKs, data connections, and connectors

resources LogManagement No -
SynapseDXIngestionBatching

Azure data explore synapse ingestion batching operations. These logs have detailed statistics of batches ready for ingestion (duration, batch size and blobs count)

resources LogManagement No -
SynapseDXQuery

Azure data explorer synpase query execution summary. Logs include DatabaseName, State, Duration that can be used for monitoring the queries which were invoked on the cluster

resources LogManagement No -
SynapseDXSucceededIngestion

Succeeded ingestion operations logs provide information about successfully completed ingest operations. Logs include data source details that together with Failed ingestion operations logs can be used for tracking the process of ingestion of each data source. Ingestion logs are supported for queued ingestion to the ingestion endpoint using SDKs, data connections, and connectors

resources LogManagement No -
SynapseDXTableDetails

Azure Data Explorer Synpase table details

resources LogManagement No -
SynapseDXTableUsageStatistics

Azure date explorer synapse table usage statistics. Logs include DatabaseName, TableName, User that can be used for monitoring cluster's table usage

resources LogManagement No -
SynapseGatewayApiRequests

Azure Synapse gateway API requests.

resources LogManagement No -
SynapseIntegrationActivityRuns

Logs for Synapse integration activity runs.

resources LogManagement No -
SynapseIntegrationPipelineRuns

Logs for Synapse integration pipeline runs.

resources LogManagement No -
SynapseIntegrationTriggerRuns

Logs for Synapse integration trigger runs.

resources LogManagement No -
SynapseLinkEvent

Information about Synapse Link, including Link status and Link table status.

resources LogManagement No Yes
SynapseRbacOperations

Azure Synapse role-based access control (SRBAC) operations.

resources LogManagement No -
SynapseScopePoolScopeJobsEnded

SCOPE ended event including SCOPE job result and Information about the job.

resources LogManagement No -
SynapseScopePoolScopeJobsStateChange

SCOPE job state change event.

resources LogManagement No -
SynapseSqlPoolDmsWorkers

Information about workers completing DMS steps in an Azure Synapse dedicated SQL pool.

resources LogManagement Yes -
SynapseSqlPoolExecRequests

Information about SQL requests or queries in an Azure Synapse dedicated SQL pool.

resources LogManagement Yes -
SynapseSqlPoolRequestSteps

Information about request steps that compose a given SQL request or query in an Azure Synapse dedicated SQL pool.

resources LogManagement Yes -
SynapseSqlPoolSqlRequests

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

resources LogManagement Yes -
SynapseSqlPoolWaits

Information about the wait states encountered during execution of a SQL request/query in an Azure Synapse dedicated SQL pool, including locks and waits on transmission queues.

resources LogManagement Yes -