Querying 1 serverless sql server db from another serverless sql server db

Ankita Gupta 0 Reputation points
2024-05-06T13:09:12.45+00:00

Hello -
I would like to check if this scenario is possible in azure synpase analytics.

Query data of serverless SQL in azure synapse analytics from another serverless sql server.

We have a requirement , where we want to create views in the second server and query data from 1st server due to the access limitation.

1st server- Read only access.

2nd Server- Admin access.

Looking forward to the response.

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,462 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vinodh247-1375 11,396 Reputation points
    2024-05-06T14:08:37.5233333+00:00

    Hi Ankita Gupta,

    Thanks for reaching out to Microsoft Q&A.

    Try using CETAS

    https://stackoverflow.com/questions/66531172/join-data-in-azure-synapse-from-dedicated-sql-pool-and-serverless-sql-pool

    you can also define external tables pointing to the data in the other instance and query them like regular tables or using synapse linked service you can query or use it for data movement.

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.