Azure / Azure/azure-cli

diagnostic-settings does not on "Dedicated SQL pool"

Open
#20,056 1 comment 0 reactions 1 assignee Claimed by @kairu-ms View on GitHub
act-observability-squad customer-reported feature-request Monitor to-vendor
Dominant language
Python
Stars
4.6k
Forks
3.5k
Avg merge
3d 2h
Merged PRs (30d)
60

Description

Hi
I have set the "diagnostic settings" on Synapse workspace and it work perfectly but it doesn't on Synapse Dedicated SQL Pool, please help, The error message is not clear (PowerShell ISE) and misleading.
Some variables are not been displayed

---------------------------------------------------------------------------------------------------------------
_Synapse dedicated SQL pool_ **NOT WORKING**

$DiagnosticsName = 'DedicatedSQLPoolDiagnostics'
$ResourceName = 'MyDedicatedSQLPoolName_DSP'
$ResourceType = 'Microsoft.Synapse/workspaces/sqlPools' # Is this right??????????
$Logs = ''
$Logs = $Logs + ' {"category": "SqlRequests" ,"enabled": true,"retentionPolicy": {"days": 10, "enabled": true}}'
$Metrics = ''

$Logs = '[' + $Logs + ']'
$Logs = $Logs.Replace('"', '""')

az monitor diagnostic-settings create --name $DiagnosticsName `
--resource-group $ResourceGroupName `
--resource-type $ResourceType `
--resource $ResourceName `
--storage-account $StorageAccount `
--logs $Logs `
--metrics $Metrics

---------------------------------------------------------------------------------------------------------------
Synapse workspace **works fine**

$DiagnosticsName = 'MySynapseDiagnostics'
$ResourceName = 'MySynapseName'
$ResourceType = 'Microsoft.Synapse/workspaces'
$Logs = ''
$Logs = $Logs + ' {"category": "IntegrationPipelineRuns","enabled": true,"retentionPolicy": {"days": 10, "enabled": true}}'
$Metrics = ''

$Logs = '[' + $Logs + ']'
$Logs = $Logs.Replace('"', '""')

az monitor diagnostic-settings create --name $DiagnosticsName `
--resource-group $ResourceGroupName `
--resource-type $ResourceType `
--resource $ResourceName `
--storage-account $StorageAccount `
--logs $Logs `
--metrics $Metrics

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.