How chkit's backfill plugin chunks, resumes, and de-duplicates large ClickHouse reingestions automatically, and runs them locally or as a managed job.
On ClickHouse you still hand-write DDL and find drift in production. Here's what changes once your schema is code: generated migrations and a drift gate.
In ClickHouse, the JOIN reflex is wrong about 80% of the time. dictGet runs 20× faster than the equivalent JOIN on a 10-billion-row enrichment. When dictionaries win, when JOINs still beat them, and how to skip the lookup entirely by enriching at ingest.
The complete ClickHouse query optimization guide: sorting keys, PREWHERE, data skipping indexes, FINAL evolution, JOIN algorithms, the diagnostic toolkit, and the anti-patterns that quietly undo everything else.
ClickHouse projections explained: internal storage, query routing, three projection types, and a decision framework for when to use them vs materialized views.
I'm always working on new ideas. Check back regularly for updates.
