Update-AzSynapseSqlPool suspend or resume not working

Herven Stefan (SEIT) 41 Reputation points
2021-01-28T06:52:46.853+00:00

Hi,

I have installed the Az.Synapse module

Install-Module -Name Az.Synapse

I have connection to the Synapse Workspace and sqlpool

Test-AzSynapseSqlPool -WorkspaceName "synws-futurefdw-devtest" -Name sqlpool
True

Now I want to suspend the sqlpool in Azure Synapse Analytics (Synapse Workspace), but I get below error message

Update-AzSynapseSqlPool -WorkspaceName theWorkspaceName -Name theSqlpoolName -Resume
Update-AzSynapseSqlPool: A parameter cannot be found that matches parameter name 'Resume'.

What could be wrong?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,477 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 79,551 Reputation points Microsoft Employee
    2021-01-28T08:56:01.087+00:00

    Hello anonymous user,

    When you look at the parameters of Update-AzSynapseSqlPool, it doesn’t have parameter name -Resume, that’s the reason you are experiencing this error message Update-AzSynapseSqlPool: A parameter cannot be found that matches parameter name 'Resume'.

    Update-AzSynapseSqlPool  
          [-ResourceGroupName <String>]  
          -WorkspaceName <String>  
          -Name <String>  
          [-Version <Int32>]  
          [-Tag <Hashtable>]  
          [-PerformanceLevel <String>]  
          [-PassThru]  
          [-AsJob]  
          [-DefaultProfile <IAzureContextContainer>]  
          [-WhatIf]  
          [-Confirm]  
          [<CommonParameters>]  
    

    Resume-AzSynapseSqlPool - Resumes a Synapse Analytics SQL pool.

    61396-image.png

    Suspend-AzSynapseSqlPool - Suspends a Synapse Analytics SQL pool.

    61382-image.png

    Hope this helps. Do let us know if you any further queries.

    ------------

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

0 additional answers

Sort by: Most helpful