Pause Data Warehouse in Synapse analytics via ADF - deny assignments

Question

When attempting to create an ADF pipeline with a web activity that calls a url to pause the DW compute (ie, a url like:
https://management.azure.com/subscriptions/@{pipeline().parameters.subscriptionId}/resourceGroups/@{pipeline().parameters.resourceGroupName}/providers/Microsoft.Sql/servers/@{pipeline().parameters.sqlServerName}/databases/@{pipeline().parameters.databaseName}/pause?api-version=2014-04-01-preview
)
I get an error like this...

"message": "{\"error\":{\"code\":\"DenyAssignmentAuthorizationFailed\",\"message\":\"The client '771...' with object id '771...' has permission to perform action 'Microsoft.Sql/servers/databases/pause/action' on scope '/subscriptions/9116..../resourceGroups/workspacemanagedrg-8ba.../providers/Microsoft.Sql/servers/syeduanalyticscisd3/databases/EduDW/pause'; however, the access is denied because of the deny assignment with name '8ba....' and Id '8ba...' at scope '/subscriptions/9116e.../resourceGroups/workspacemanagedrg-8ba...'.\"}}",

I'm not able to find the Deny assignment anywhere in the subscription. Is there a workaround that will allow me to invoke the pause endpoint for Azure Synapse Analytics?

Answer 1

I found the answer - the correct API to use for Synapse Analytics is this one: https://learn.microsoft.com/en-us/rest/api/synapse/sqlpools

I was able to get it working by using this endpoint: https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/pause?api-version=2019-06-01-preview