Create Azure SQL Analytics via Powershell

Question

I'm wondering if there is a specific Powershell command to create Azure SQL Analytics resource. So far I've only found how to enable sending diagnostics logs to a Log Analytics workspace.

I assume I can try arm template, but it will be nice if there is a dedicated command to avoid creating another json template.

can you specify what you want to create exactly? show a screenshot or, preferably, resource definition — 4c74356b41, Apr 03 '19 at 17:47
@4c74356b41 I've described it in the question- it's Azure SQL Analytics. I'll make it as a link to be more clear — Kiryl, Apr 03 '19 at 18:40
you just need to add this solution to azure monitor (or whatever its called now)? — 4c74356b41, Apr 03 '19 at 18:43
@4c74356b41 to a Log Analytics workspace. And I want to automate it — Kiryl, Apr 03 '19 at 18:51

score 0 · Accepted Answer · answered Apr 03 '19 at 19:12

You can use the following powershell:

Set-AzOperationalInsightsIntelligencePack -ResourceGroupName rgName -WorkspaceName workspaceName -IntelligencePackName AzureSQLAnalytics -Enabled $true

Reading: https://learn.microsoft.com/en-us/azure/azure-monitor/platform/powershell-workspace-configuration#create-and-configure-a-log-analytics-workspace

Create Azure SQL Analytics via Powershell

1 Answers1