Chapter 6: Databricks Delta Lake
Delta Lake is an open source storage layer that provides functionalities to data in the data lake that only exist in data warehouses. When combined with cloud storage, Databricks and Delta Lake lead to the formation of a Lakehouse. A Lakehouse simply provides the best of both worlds – data lakes and data warehouses. In today's world, a Lakehouse provides the same set of capabilities as a traditional data warehouse and at a much lower cost. This is made possible due to cheap cloud storage such as Azure Data Lake, Spark as the processing engine, and data being stored in the Delta Lake format. In this chapter, we will learn about various Delta Lake optimizations that help us build a more performant Lakehouse.
In this chapter, we will cover the following topics:
- Working with the
OPTIMIZE
andZORDER
commands - Using
AUTO OPTIMIZE
- Learning about delta caching
- Learning about dynamic partition pruning
- Understanding bloom...