Synpase workspace - How do I manage multiple projects spread across different teams in a single synapse workspace ?

Question

Hi Team,

Can you please guide me on How do I manage multiple projects spread across different teams in a single synapse workspace ? We want to put restrictions on Notebooks, Sql scripts and data access basis project.

Should we go with multiple workspace or is it possible to do access control in one workspace itself at folder level. ?

In case of multiple workspace - How dedicated SQL Pool sharing will work ?

Cheers,
Raghav

Answer 1

Hi

Thanks for reaching out to Microsoft Q&A.

This is, atleast some of it is in-line with your previous question that you have raised.

Can you check if the below answer 'wBob' will suit for your ask? it's worth to check the replies too, it might provide you guidance if not an exact solution.

https://stackoverflow.com/a/68455706

Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

Answer 2

Hi @Kumar, Raghav ,

Thank you for posting query in Microsoft Q&A Platform.

Similar, query addressed in below link. Kindly check it.
https://learn.microsoft.com/en-us/answers/questions/1144062/synapse-dedicated-pool-how-to-share-production-rea.html?childToView=1146565#answer-1146565

Hope this helps. Please let me know if any further queries.

--------------

Please consider hitting Accept Answer button. Accepted answers help community as well.

Answer 3

Hi,

What I infer from your question is that you are looking to secure the objects within workspace and limit the access across different teams working on different projects. This might become a cumbersome task and might incur a mighty overhead over a long run when there are too many objects and too many projects using the same workspace.

There are various factors to be considered before deciding on having multiple workspace. Some of the key factors are

• Running Cost and Cost Management
• Team Structure and Responsibilities
• Development and Deployment – Release Workflow
• Productivity and Project Management
• Efficiency of Shared Data
• Data Sharing, Security and Governance

Refer to the link below for how and when to have multiple workspace. It also speaks about sharing sql pool and data lake store.

https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/the-best-practices-for-organizing-synapse-workspaces-and/ba-p/3002506