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 21 Reputation points
2023-03-30T19:52:08.8933333+00:00

is it possible to query a data lake with a dedicated sql pool in Azure like you can with a serverless sql pool?

Azure SQL Database
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,447 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,709 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee
    2023-03-30T20:17:21.34+00:00

    @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

    User's image

    This functionality is still not available.

    As a workaround, you can create external tables in a dedicated pool and query lake

    Regards

    Geetha

    1 person found this answer helpful.
    0 comments No comments