A series of ClickHouse cheatsheets covering the analytics database for OLAP workloads.
Start with Cheatsheet 01 — ClickHouse Basics .
ClickHouse Cheatsheet 01 — ClickHouse Basics
Cheatsheet: install, client, tables, queries.
ClickHouse Cheatsheets
20 practical ClickHouse cheatsheets — analytics DB, queries, engines.
ClickHouse Cheatsheet 02 — MergeTree Engines
Cheatsheet: MergeTree, Replacing, Summing, Aggregating, Collapsing.
ClickHouse Cheatsheet 03 — Materialized Views
Cheatsheet: MV basics, AggregateFunction, refreshable.
ClickHouse Cheatsheet 04 — Query Optimization
Cheatsheet: query patterns, primary key usage, projections.
ClickHouse Cheatsheet 05 — Compression
Cheatsheet: codecs, LowCardinality, encoding.
ClickHouse Cheatsheet 06 — Distributed Cluster
Cheatsheet: shard/replica, ON CLUSTER, Distributed table.
ClickHouse Cheatsheet 07 — Ingest Patterns
Cheatsheet: ingest patterns, Buffer, Kafka, async inserts.
ClickHouse Cheatsheet 08 — Time-Series Patterns
Cheatsheet: time-series, bucketing functions, rollups, retention.
ClickHouse Cheatsheet 09 — Window Functions and Analytics
Cheatsheet: window functions, retention, funnel analysis.
ClickHouse Cheatsheet 10 — Backup
Cheatsheet: BACKUP TO, FREEZE PARTITION, restore.