diagnostic-settings does not on "Dedicated SQL pool"
- 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
Assessment
This issue has not been assessed yet.