How can I share a provisioned Synapse Dedicated Pool within a Workspace with other workspaces?

paulocorreia 6 Reputation points
2020-12-04T10:54:40.857+00:00

Is it possible to share a dedicated Synapse DB Pool created inside a workspace, with other workspaces?

if yes? How?

If not? is it being considered?

Synapse itself is a very powerful resources to be tied with only a workspace.

If we have multiples teams developing pipelines for different projects, it will be come messy and hard to manage 1 single workspace just because of Synapse DB pool affinity.

Azure Synapse Analytics
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.
4,316 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vedant Desai 631 Reputation points
    2023-05-15T11:13:10.0833333+00:00

    Hey @paulocorreia

    Currently, it is not possible to share a dedicated Synapse DB Pool created inside a workspace, with other workspaces. However, this is a feature that is being considered by Microsoft.

    In the meantime, there are a few workarounds that you can use to share a Synapse DB Pool between workspaces. One workaround is to create a Data Share. A Data Share is a way to share data between workspaces. To create a Data Share, you will need to:

    1. Go to the Azure portal and navigate to your Synapse Analytics workspace.
    2. In the left navigation pane, select Data Share.
    3. Click + Create Data Share.
    4. Enter a name for your Data Share.
    5. Select the type of data that you want to share.
    6. Select the workspaces that you want to share the data with.
    7. Click Create.

    Once you have created a Data Share, you can access the shared data in the Synapse Analytics workspaces that you selected.

    Another workaround is to use a linked server. A linked server is a way to connect to a database in another workspace. To create a linked server, you will need to:

    1. Go to the Azure portal and navigate to your Synapse Analytics workspace.
    2. In the left navigation pane, select Linked Servers.
    3. Click + Create Linked Server.
    4. Enter a name for your linked server.
    5. Enter the name of the database that you want to connect to.
    6. Enter the server name or IP address of the database server.
    7. Enter the login credentials for the database.
    8. Click Create.

    Once you have created a linked server, you can connect to the database in the other workspace using the linked server name.

    I hope this helps!

    0 comments No comments