The SQL Warehouses
In this chapter, we will focus on the compute layer of the Lakehouse architecture. The compute layer in Databricks SQL is called the SQL Warehouse. We will learn how to create SQL Warehouses and configure them for the best possible user experience. We will also learn how the computation layer is instantiated on demand when a user executes a query.
The primary audience of this chapter is the Database administrators and Databricks workspace administrator personas. That said, Data analyst personas will also benefit from this chapter by learning how their queries are executed, how to avoid common pitfalls, and how to get the best possible performance.
In this chapter, we will cover the following topics:
- Understand the SQL Warehouse architecture
- Creating and configuring SQL Warehouses
- The art of SQL Warehouse sizing
- Organizing and governing SQL Warehouses
- Using Serverless SQL
