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
@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 Z
you just need to add this solution to azure monitor (or whatever its called now)? — 4c74356b41
@4c74356b41 to a Log Analytics workspace. And I want to automate it — Kiryl Z

4c74356b41 4c74356b41 · Accepted Answer · 2019-04-03T19:12:33

You can use the following powershell:

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

Reading: https://docs.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 Answers