Forum Discussion
Solved
Dedicated SQL Pool Automation
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.
- Reviewed the following link and was able to get things to work: https://learn.microsoft.com/en-us/answers/questions/1191295/how-to-auto-scaleup-and-scaledown-the-dwu-in-azure
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 ?- Reviewed the following link and was able to get things to work: https://learn.microsoft.com/en-us/answers/questions/1191295/how-to-auto-scaleup-and-scaledown-the-dwu-in-azure
