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