Accessing steps to tables across SQL server pools in synapse workspace

Question

Hello, we are currently working with two SQL Server Pools and facing an issue. We're trying to access Table1 from Pool1 using a SQL Script in Synapse Workspace, but we receive an error message stating, "This feature is not supported in this version of SQL Server." Is there a method to access this table directly using SQL Server scripts, or do we need to rely on alternative solutions such as Pipelines, Spark notebooks, or External tables?

Specifically, we're looking to reference a table from a different SQL Pool within the Synapse workspace.

Answer 1

Hi @Pravalika-randstad

Welcome to Microsoft Q&A Platform. Thank you for posting your query.

The error message "This feature is not supported in this version of SQL Server" indicates that the SQL script is trying to access a table from a different SQL pool within the Synapse workspace, which is not supported in the current version of SQL Server.

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.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.