A SQL warehouse is a compute resource that lets you run SQL commands on data objects within Databricks SQL. Compute resources are infrastructure resources that provide processing capabilities in the cloud. Your SQL warehouse connects you to the compute and data that you use to run your SQL queries. For information on creating SQL warehouses, see Create a SQL warehouse.
Databricks SQL supports two warehouse types, each with different levels of performance and feature support.
Pro: Supports additional Databricks SQL performance features (compared to classic) and supports all Databricks SQL functionality.
Classic: Supports entry level performance features and a limited set of Databricks SQL functionality. The classic SQL warehouse type is not enabled by default.
Using the UI, the default SQL warehouse type is pro.
Using the SQL Warehouses API with default parameters, the default SQL warehouse type is classic.
Databricks SQL also provides a robust API for your programming needs.
You can use a variety of developer tools to run SQL commands and scripts and to browse database objects in Databricks. See Use a SQL database tool.