Knowledge base

The vocabulary of the open lakehouse.

Each entry covers one idea: what it is, the problem it solves, where it stops, and which primary sources to read next. Start at the top if the whole architecture is new to you, or go straight to a technology if you already know where you are.

Concepts

The layers and ideas that make up the architecture, in the order they build on each other.

  1. 01What is an open lakehouseA data architecture that keeps analytical data in open formats on object storage you control, readable by any compliant engine.
  2. 02Object storageThe durable, cheap byte store at the bottom of the stack, and the constraints it imposes on everything above it.
  3. 03File formatHow records are arranged inside a single file, which decides how much of it a query has to read.
  4. 04Table formatThe metadata layer that turns a collection of files into a table with atomic commits, schema evolution, and history.
  5. 05CatalogThe service that resolves table names, performs the atomic commit, enforces access, and hands out scoped credentials.
  6. 06Semantic layerWritten definitions of what the data means, so people and machines compute the same metric the same way.
  7. 07Query enginesThe compute that reads the stack, kept separate from storage so you can run several and replace any of them.
  8. 08PartitioningHow table data is physically grouped so a query can skip whole sections of it, and why hiding the scheme matters.
  9. 09ACID and time travelHow a lakehouse gets safe concurrent writes and a readable past, using an atomic pointer swap rather than a lock.
  10. 10Table maintenanceCompaction, snapshot expiration, and orphan cleanup, and what happens to a table when nobody owns them.
  11. 11The four kinds of openOpen source, open formats, open interfaces, and open governance are separate claims, and conflating them is how lock-in survives.
  12. 12Portability and lock-inWhat it would actually cost to change each component, and why the answer is usually discovered too late.
  13. 13AI and the lakehouseWhy AI workloads make the same architectural properties matter more, and what they add on top.

Key technologies

The five open projects that carry most of the weight in a modern lakehouse, one page each.

Two newsletters, one list

Read the week before you build.

I write two free weekly newsletters on Substack. One subscription gets you both.

Subscribe on Substack