Module 29 · Applied

The slow, expensive lakehouse

A production lakehouse is slow and costly. Diagnose it from the evidence and fix it.

In plain words

A production lakehouse is slow and expensive, and it's your job to find out why. Using metrics, table metadata and query plans, you'll diagnose several problems at once and fix them.

Helps to take first

Keeping tables healthy File layout, clustering & data skipping

Words you'll meet

Small-files problem Compaction VACUUM Partition Data skipping

This module is in production

Here's what it will cover.

Centrepiece

Investigate metrics, table metadata and query plans to find and fix five compounding problems

You will understand

Diagnosing layout, maintenance, partitioning and pipeline issues together

Formats

Fix the problemLive simulationCheckpoints