Configuring dedicated SQL pool to query data lake

Question

Is there a way to configure a dedicated SQL Pool to be able to query an Azure Data Pool like the way a serverless SQL Pool can?

Answer 1

Hello @Tran, Peter ,

Thanks for the question and using MS Q&A platform.

Unfortunately, you cannot query Lake database using dedicated SQL pool.

Reason: The lake database is exposed in Synapse SQL serverless SQL pool and Apache Spark providing users with the capability to decouple storage from compute. The metadata that is associated with the lake database makes it easy for different compute engines to not only provide an integrated experience but also use additional information (for example, relationships) that was not originally supported on the data lake.

For more details, refer to Azure Synapse Analytics - Lake database.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of Q&A Volunteer Moderators