11. SQL Warehouses

11.1 What is an SQL warehouse?

A SQL warehouse is a compute resource that lets you query and explore data on Azure Databricks. It is recommended to use serverless SQL warehouses because they are quick to start, require minimal management and are more efficient.

SQL Warehouse

At NS, you have already been provided with the ns-ii-tech-dev-sql warehouse which has already been pre-configured for your use.

11.2 Practical

To create a SQL warehouse, click on the Create SQL warehouse button at the top right. A new interface opens up.

Create SQL warehouse

For more details how to optimize the cluster and scaling, see this link.