10

Warehouse on the Lakehouse

Traditional data warehousing implementations are comprised of different components such as a staging area, operational data store, enterprise data warehouse, and data marts. Depending on the implementation of the system, these components may or may not be transparent to the user. One of the biggest mental leaps you must take when adopting the Lakehouse is how to translate these components to the Lakehouse.

In this chapter, we will learn how to design and implement these components on the Lakehouse using Delta Lake features and ETL design patterns of the Lakehouse.

In this chapter, we will cover the following topics:

  • Organizing data on the Lakehouse
  • Implementing data modeling techniques

The primary audience of ...

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.