AzPolicyAdvertizer

last sync: 2025-Aug-20 17:22:59 UTC

Deploy Diagnostic Settings for SQL Pool under Synapse Analytics to Log Analytics workspace

Community Policy definition

Source Repository Community-Policy GitHub
JSON Community-Policy GitHub
Deploy policy 4a37ed92-42d3-45f1-8325-35bc4aff8db8 (1.0.0) to Azure
Display name Deploy Diagnostic Settings for SQL Pool under Synapse Analytics to Log Analytics workspace
Id 4a37ed92-42d3-45f1-8325-35bc4aff8db8
Version 1.0.0
Details on versioning
Category Monitoring
Microsoft Learn
Description Deploys the diagnostic settings for SQL Pools under Synapse Analytics to stream to a Log Analytics workspace when any SQL Pools under Synapse Analytics which is missing this diagnostic settings is created or updated. The policy will set the diagnostic with all metrics and category enabled.
Mode Indexed
Type Custom Community
Effect Default
DeployIfNotExists
Allowed
DeployIfNotExists, AuditIfNotExists, Disabled
RBAC role(s)
Role Name Role Id
Log Analytics Contributor 92aaf0da-9dab-42b6-94a3-d43ce8d16293
Monitoring Contributor 749f88d5-cbae-40b8-bcfc-e573ddc772fa
Rule aliases THEN-ExistenceCondition (3)
Alias Namespace ResourceType Path PathIsDefault DefaultPath Modifiable
Microsoft.Insights/diagnosticSettings/logs.enabled microsoft.insights diagnosticSettings properties.logs[*].enabled True False
Microsoft.Insights/diagnosticSettings/metrics.enabled microsoft.insights diagnosticSettings properties.metrics[*].enabled True False
Microsoft.Insights/diagnosticSettings/workspaceId microsoft.insights diagnosticSettings properties.workspaceId True False
Rule resource types IF (1)
Microsoft.synapse/workspaces/sqlpools
JSON
EPAC
Deploy policy 4a37ed92-42d3-45f1-8325-35bc4aff8db8 (1.0.0) to Azure