question

AruhnRamasubramanian-0157 avatar image
0 Votes"
AruhnRamasubramanian-0157 asked SamaraSoucy-MSFT answered

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered VaibhavChaudhari edited

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


image.png (9.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SamaraSoucy-MSFT avatar image
0 Votes"
SamaraSoucy-MSFT answered

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/')


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.