Azure SQL Database
An Azure relational database service.
5,011 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
is it possible to query a data lake with a dedicated sql pool in Azure like you can with a serverless sql pool?
@Tran, Peter Thanks for posting your question in the Microsoft Q&A forum.
No, it is not possible to query a data lake with a dedicated SQL pool in Azure please check the reference document,
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset
This functionality is still not available.
As a workaround, you can create external tables in a dedicated pool and query lake
Regards
Geetha