Referring the table from different SQL Pool in Synapse workspce

Question

Hi - We have two SQL Server Pools and trying to access the Table1 from Pool1 in Pool2 using SQL Script in Synapse Workspace and its saying "This feature is not supported in this version of SQL Server". Is there any way to access it in SQL Server script or I need to use Pipelines/Spark notebooks/External tables.

thanks

Answer 1

Hi @rajendarerabathini-1405,

Welcome to Microsoft Q&A forum and thanks for reaching out.

I’m assuming these are provisioned (dedicated) sql pools? If yes, then cross database joins are not supported. You will need to extract/load via Integration Pipeline/Spark.

Please feel free to submit your feedback in Azure Synapse Analytics user voice forum. All the feedback shared in this forum are actively monitored and reviewed by Synapse product team. Also please do share the feedback link here once it is posted as it would help others to up-vote and/or comment on your idea.

Here is an already existing feature request, please feel free to up-vote and/or comment : Cross Database Querying

Hope this helps. Let us know if you have further query.

Thank you

---

Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.