Share via

Cross-db query in Synapse

prbchic 20 Reputation points
2023-07-26T16:45:33.2566667+00:00

Hi,

I am pretty new to Azure Synapse

  1. This post mentions that it is possible to have only one database per SQL pool. However, this post was from 2 years ago. Is this still the case?
  2. Assuming that only one database can be created within a SQL pool, is it possible to write queries joining tables from dbs in different SQL pools? Essentially I am trying to figure out if the functionality of cross db queries, which is possible in Snowflake, is also possible in Synapse?

Please let me know if more context/information needs to be provided for the above questions.

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.
5,378 questions
0 comments
Accepted answer
  1. Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator
    2023-07-26T16:53:38.6133333+00:00

    Hey,

    Synapse/Azure SQL dedicated pool as of now doesnt support cross database query.

    you can query the SQL Pool tables from an Azure SQL database via elastic query but not vice versa.

    Can you please clarify by what you mean : one database per SQL pool ?

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
    2023-07-27T00:00:31.7233333+00:00

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

    As per my internal research, I can confirm that, as @Nandan Hegde mentioned, as of today Azure Synapse doesn't support cross-database queries. Looks like it is in the road map, but we don't know the ETA yet.

    I would recommend you to please subscribe to Azure updates page so that you can get the latest information about upcoming azure product features.

    If you have any additional feedback regarding the product features, please feel free to log it in Synapse IDEAS forum here: https://feedback.azure.com/d365community/forum/9b9ba8e4-0825-ec11-b6e6-000d3a4f07b8 and do share the feedback link once it is posted so that we can share it with respective product owner for further review.

    I have also found an existing feature request idea logged by other users. Please feel free to comment and upvote on it to help increase priority of the request - Cross Database Querying

    Hope this info helps. If the response from @Nandan Hegde was helpful, please don’t forget to Accept Answer and click Yes for "was this answer helpful" on his answer, as this can be beneficial to other community members reading this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.