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
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