Summary

In this short but very important chapter, we learned how we can connect our preferred BI tools to Databricks SQL and query the data on the data lakehouse.

First, we learned about the various connection configurations that must be made. Then, we learned about the differences between validated and non-validated BI tool integrations. Finally, we learned about the Databricks Partner Connect feature, which simplifies the process of connecting our preferred BI tool with Databricks SQL.

Now, you should have a working understanding of Databricks SQL from an end user perspective, as well as an administrator’s perspective. You should be good to start working with Databricks SQL. Now, we will turn our attention to the core technology enablers that power Databricks SQL.

In the next chapter, Chapter 8, The Delta Lake, we will unpack the internals of the storage layer of the lakehouse and focus on the Delta Lake storage format. We will learn how it enables Data Warehouse...