Can I share a logical DB created in a Synapse Workspace using SQL Serverless Pool with another Synapse Workspace

Aruhn Ramasubramanian 1 Reputation point
2021-03-30T08:44:20.687+00:00

I have created a logical DB using Synapse Serverless SQL Pool inside a Synapse Workspace.
I want to create another Synapse Workspace and have it refer to the DB created inside the above-mentioned Workspace.
Both Workspaces share the same Gen2 backend as primary.
Can I do this.

Thanks in advance!

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,395 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,601 Reputation points
    2021-03-30T10:54:32.78+00:00

    I added this flag in release task to fix similar issue, see if this works

    82749-image.png

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.
    0 comments
  2. Samara Soucy - MSFT 5,051 Reputation points
    2021-03-31T16:25:34.87+00:00

    The second instance won't automatically import the database, but you can use external tables to make the data easily accessible from there. 

    CREATE EXTERNAL DATA SOURCE SqlOnDemandDemo WITH (  
    LOCATION = 'https://sqlondemandstorage.blob.core.windows.net'  
);  
GO  
CREATE EXTERNAL DATA SOURCE YellowTaxi  
WITH ( LOCATION = 'https://azureopendatastorage.blob.core.windows.net/nyctlc/yellow/')
    0 comments