Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #140: Is it possible to connect from Azure SQL DB to Synapse using External Tables?

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Oct 21, 2020
Today, I got a very good question from a customer that they want to connect using Azure SQL DB to several tables of Azure Synapse using External Tables. Following I would like to share what was the l...
Updated Oct 22, 2020
Version 2.0
Johannes_Vink's avatar
Johannes_Vink
Brass Contributor
Oct 22, 2020

The other way around would be interesting too 😉

 

Let Azure Synapse SQL-on-demand query Azure SQL DB. So that we can enhance the flat files on blob via SQL-on-demand with some lookup tables stored in Azure SQL DB.