Lesson Learned #177: Is possible to use Private Endpoint with Azure SQL External Tables?

Published Jun 17 2021 11:08 AM 991 Views

Today, we had a question from a customer asking if could be possible to connect to the Private Endpoint of Azure SQL DB or Synapse using Azure SQL External Tables.

 

The current answer is not, due to, as outbound connections for Azure SQL External Tables are executing from backend nodes that are outside of any private endpoint addressing space. 

 

In this situation, there is not possible and won't be available in a near future, as alternative, using Azure SQL Managed Instance that allows to use cross database queries among the database that belongs to the same instance or you could use Linked Server. 

 

 

%3CLINGO-SUB%20id%3D%22lingo-sub-2459838%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%23177%3A%20Is%20possible%20to%20use%20Private%20Endpoint%20with%20Azure%20SQL%20External%20Tables%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2459838%22%20slang%3D%22en-US%22%3E%3CP%3EToday%2C%20we%20had%20a%20question%20from%20a%20customer%20asking%20if%20could%20be%20possible%20to%20connect%20to%20the%20Private%20Endpoint%20of%20Azure%20SQL%20DB%20or%20Synapse%20using%20Azure%20SQL%20External%20Tables.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20current%20answer%20is%20not%2C%20due%20to%2C%20as%20outbound%20connections%20for%20Azure%20SQL%20External%20Tables%20are%20executing%20from%20backend%20nodes%20that%20are%20outside%20of%20any%20private%20endpoint%20addressing%20space.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20this%20situation%2C%20there%20is%20not%20possible%20and%20won't%20be%20available%20in%20a%20near%20future%2C%20as%20alternative%2C%20using%20Azure%20SQL%20Managed%20Instance%20that%20allows%20to%20use%20cross%20database%20queries%20among%20the%20database%20that%20belongs%20to%20the%20same%20instance%20or%20you%20could%20use%20Linked%20Server.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2459838%22%20slang%3D%22en-US%22%3E%3CP%3EToday%2C%20we%20had%20a%20question%20from%20a%20customer%20asking%20if%20could%20be%20possible%20to%20connect%20to%20the%20Private%20Endpoint%20of%20Azure%20SQL%20DB%20or%20Synapse%20using%20Azure%20SQL%20External%20Tables.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎Jun 17 2021 11:08 AM
Updated by: