Skip to content

Blog

Notes on data engineering, pipeline architecture, and things I've learned building systems at scale.

· 3 min read

Backfilling Materialized Views in ClickHouse with Null Tables

If you’ve ever changed the logic on a ClickHouse materialized view and needed to reprocess historical data, you’ve probably hit this problem. The MV only processes new inserts. Old data just sits there. The Null table engine is a clean way to fix that.

clickhouse data-engineering