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:
- Go to the Azure portal and navigate to your Synapse Analytics workspace.
- In the left navigation pane, select Data Share.
- Click + Create Data Share.
- Enter a name for your Data Share.
- Select the type of data that you want to share.
- Select the workspaces that you want to share the data with.
- 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:
- Go to the Azure portal and navigate to your Synapse Analytics workspace.
- In the left navigation pane, select Linked Servers.
- Click + Create Linked Server.
- Enter a name for your linked server.
- Enter the name of the database that you want to connect to.
- Enter the server name or IP address of the database server.
- Enter the login credentials for the database.
- 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!