Setting Up Environments for Synapse Analytics/Dedicated SQL Pool: Workspace and SQL Pool Confrguration Inquiry

Question

I must set up development, testing, and production environments for Synapse Analytics or a dedicated SQL pool.

Specifically, should I establish separate workspace for each environment, or is it feasible to have a single workspace and create distinct dedicated SQL pools for each environment?

Answer 1

Hi Pravalika-randstad:

Thanks for reaching out to Microsoft Q&A.

Dedicated pools under the workspace are like databases under an SQL Server instance, by nature all of them will be unrelated and unique. You can create multiple dedicated pool databases inside one single workspace and use them for different environments if you want.

Let me know if this info helped.

Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.