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

Pravalika-randstad 160 Reputation points

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?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,508 questions
{count} votes

Accepted answer
  1. Vinodh247 7,416 Reputation points

    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.

    User's image

    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.

0 additional answers

Sort by: Most helpful