Join between Serverless sql pool and Azure SQL

Napegadie Kone 0 Reputation points Microsoft Employee
2023-10-20T12:17:17.24+00:00

Do you have any recommendations on how to join tables in Serverless SQL Pool with table in Azure SQL? Any pros and cons?

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

1 answer

Sort by: Most helpful
  1. Konstantinos Passadis 19,166 Reputation points MVP
    2023-10-20T12:31:31.0633333+00:00

    Hello @Napegadie Kone

    Welcome to Microsoft QnA!

    For starters have a look here :

    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool

    I have been quite engaged with Synapse and external Tables

    You can use the OPENROWSET function to query Azure SQL Database directly, bypassing the need for an external table.

    OR

    Create an external table in Synapse that points to your Azure SQL database table

    Pros and Cons :

    Be careful with costs while Serverless is only pay per usage extensive usage can incure costs

    Performance may also affect the overall experience as large Datasets can take time to run queries

    A managed Environment though is always a pro , and maybe costs witha proper Cost Management plan can be an advantage

    You can always try the Solution in mind and come back with your feedback !


    I hope this helps!

    Kindly mark the answer as Accepted and Upvote in case it helped!

    Regards

    0 comments No comments

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.