![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Azure SQL Database
An Azure relational database service.
6,326 questions
@Shambhu Rai - Thanks for the question and using MS Q&A platform.
Azure Databricks provides two types of SQL endpoints: SQL Data Warehouse and Serverless SQL Pool**.** SQL Data Warehouse is a dedicated cluster that provides high-performance analytics and data warehousing capabilities. On the other hand, Serverless SQL Pool is a pay-per-query service that allows you to query data stored in Azure Blob Storage, Azure Data Lake Storage, and Azure Synapse Analytics.
SQL Data Warehouse is a good choice when you need to run complex queries on large datasets and require high-performance analytics. It provides a dedicated cluster that can be scaled up or down based on your needs. However, it requires more management and maintenance compared to Serverless SQL Pool.
Serverless SQL Warehouse, on the other hand, is a good choice when you need to query data on an ad-hoc basis and don't want to manage a dedicated cluster. It provides a pay-per-query model, which means you only pay for the queries you run. It also provides automatic scaling and can handle large datasets. However, it may not be suitable for running complex queries on very large datasets.
The following diagram shows important differences between the serverless data plane and classic data plane for both serverless features.
For more details, refer to Compare serverless compute to other Azure Databricks architectures.
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.