Summary

In this chapter, we put on the lens of a Database administrator and learned about SQL Warehouses in depth.

First, we learned how SQL Warehouses can be created, configured, and governed. We discussed the inner workings of SQL Warehouses so that we can configure them to get the best possible user experience. We discussed various strategies for assigning users to SQL Warehouses. Finally, we discussed how we can charge back users for their usage and create accountability.

SQL Warehouses are used within the Databricks SQL UI. However, they can also be leveraged from outside the Databricks environment with specialized BI tools.

In Chapter 7, Using Business Intelligence Tools with Databricks SQL, we will learn how to do this and elevate the analyst experience.