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.
5,233 questions
Recommended CI/CD Setup for Azure Synapse
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 28.999999999999996%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFS%3C/text%3E%3C/svg%3E)
Finn Schmidt
86
Reputation points
Most tutorials and recommendations for how to set up CICD in azure synapse suggest creating multiple workspaces (e.g. -dev, -qa, -uat, -prod) and using a devops pipeline to move artifacts between the environments. Including this video tutorial from the AzureSynapse youtube channel:
https://www.youtube.com/watch?v=UhpboCdNh1I
While this approach works reasonably well, it is in direct conflict with the limit for synapse workspaces in a subscription, which allows at most 2 workspaces per subscription:
I tried opening a support ticket to increase the quota limit, but only got the feedback that this is a hard limit that cannot be increased.
Am I missing something? This hard limit seems rather unreasonable to me, and not in line with the best practises.
Thank you!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 99%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
J N S S Kasyap 865 Reputation points Microsoft External Staff2025-03-11T18:55:49.34+00:00 Hi @Finn Schmidt
I understand your concern regarding the workspace limit for Azure Synapse, especially in relation to CI/CD best practices.
Currently, for Pay-As-You-Go, Free Trial, Azure Pass, and Azure for Students subscriptions, the maximum allowed number of Synapse workspaces per subscription istwo, and unfortunately, this limit cannot be increased.
If you require additional workspaces, switching to an Enterprise Agreement (EA) or Cloud Solution Provider (CSP) subscription may offer higher limits.Please find the Microsoft docs useful links below
https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/azure-subscription-service-limits
https://learn.microsoft.com/en-us/azure/cost-management-billing/manage/create-enterprise-subscriptionI hope this information helps. Please do let us know if you have any further queries.
Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.
Thank you.
-
J N S S Kasyap 865 Reputation points Microsoft External Staff
2025-03-12T16:40:00.17+00:00 @Finn Schmidt
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer