CODEWITHSUNDEEP
azurepowershellazure-runbookazure-synapse
priyanshu
priyanshu

Reputation: 3

The term 'Get-AzSynapseSqlPool' is not recognized as a name of a cmdlet

I was tryng to upscale synapse using azure runbook in powershell but the commands listed in https://learn.microsoft.com/en-us/powershell/module/az.synapse/get-azsynapsesqlpool?view=azps-7.1.0#code-try-3 are not recognisable with the error "The term 'Get-AzSynapseSqlPool' is not recognized as a name of a cmdlet, | function, script file, or executable program. Check the spelling of the | name, or if a path was included, verify that the path is correct and try | again." can anyone help?

Upvotes: 0

Views: 1155

Answers (1)

Harshitha Veeramalla
Harshitha Veeramalla

Reputation: 1753

Go to Portal =>Automation Accounts =>Your Shared Resource =>Runbook Check if you have Az.Synapse module. If not , add a module from the local machine and import it to the runbook using

 Import-module -name Az.Synapse

Command for upscaling service tier of synapse sql pool

Set-AzSqlDatabase -ResourceGroupName "resourcegroupname" -DatabaseName "mySampleDataWarehouse" -ServerName "sqlpoolservername" -RequestedServiceObjectiveName "DW300c"

Please refer Updates a Synapse Analytics SQL pool and Scale compute for dedicated SQL pool for more information.

Upvotes: 1

Related Questions