Cover of The Lakehouse Built for Everyone by Alex Merced

The Lakehouse Built for Everyone

Published by Self-published · Tech

From laptop prototypes to enterprise-scale agentic AI with Apache Iceberg and Dremio.

About the author: Alex Merced is Head of Developer Relations at Dremio and the author of 77 books on data, AI, economics, fiction, and tabletop RPGs. His story is on WhoIsAlexMerced.com.

Who this book is for

Data engineers, analytics engineers, software developers, and technical leaders who want practical blueprints for an Apache Iceberg lakehouse, whether they are leaving a legacy cloud warehouse, adding generative AI to BI, or learning the Iceberg ecosystem.

Table of contents

  1. The Foundation: Data Lakehouses, Parquet, and Arrow
  2. The Metadata Layer: Apache Iceberg and Apache Polaris
  3. The Compute Ecosystem: Dremio, DuckDB, and Polars/Datafusion
  4. The Modern Data Platform Dilemma
  5. The Heart of the Lakehouse: Deep Dive into Iceberg
  6. Setting Up Your Dremio Open Catalog
  7. Ingesting Data with PyIceberg
  8. Analytical Engines: DuckDB and DataFusion
  9. When Your Laptop Isn't Enough: Knowing When to Scale
  10. Introducing Dremio: Scaling Down to Minimize Costs
  11. Federated Queries (Connecting Across Silos)
  12. Natural Language Analytics (AI Agent Basics)
  13. Using MCP Server with Local/Cloud Contexts
  14. Crossing the Boundary (Moving Compute Entirely to Dremio)
  15. Autonomous Optimization (Let the Engine Do the Work)
  16. Building a Strict Semantic Layer for the Organization
  17. Maximizing AI Quality (How the Semantic Layer Powers Agents)
  18. The Open Foundation (Avoiding Vendor Lock-In)

Excerpt

Data has gravity. The moment you place a terabyte of information into a proprietary database, it begins pulling your budget, your engineering time, and your architectural decisions toward that single vendor. Ten years ago, data engineers accepted this gravity as a law of physics. If you wanted fast, reliable SQL analytics, you paid a premium for an enterprise data warehouse. If you wanted cheap storage for unstructured files, you dumped them into a data lake. Organizations ran both systems simultaneously, building complex pipelines to shuffle data between the cheap swamp and the expensive fortress.

Related books

Work with Alex