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 ...

Get Business Intelligence with Databricks SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.