SOLVED

Dedicated SQL Pool Automation

Brass Contributor

I have pipelines running that will turn on/off the dedicated SQL pool.  I tried to add in the parameter and call to be able to scale up and down.

 

When it gets to the point of scaling, it fails due to a permissions error.  I can't seem to find where the permissions need to be set to allow the pipeline (Managed Identity) to scale.

3 Replies
Microsoft.Sql/servers/databases/write is the permission needed to scale a Dedicated pool
1) Where is this applied to (within Azure or within the DB)?
2) If this is within the DB, is there a TSQL syntax/reference to add this same permission?

When looking for the exact path you mentioned, there is limited information on how to apply this. Also, will this work for a Synapse dedicated SQL pool or only Azure SQL ?
best response confirmed by MWLjdb (Brass Contributor)
Solution
1 best response

Accepted Solutions
best response confirmed by MWLjdb (Brass Contributor)