A series of ClickHouse cheatsheets covering the analytics database for OLAP workloads.
Start with Cheatsheet 01 — ClickHouse Basics .
ClickHouse Cheatsheet 11 — Settings and Tuning
Cheatsheet: settings, profiles, quotas.
ClickHouse Cheatsheets
20 practical ClickHouse cheatsheets — analytics DB, queries, engines.
ClickHouse Cheatsheet 12 — Operations and Monitoring
Cheatsheet: system tables, query_log, metrics.
ClickHouse Cheatsheet 13 — Joins and Subqueries
Cheatsheet: JOIN types, dict alternative, IN.
ClickHouse Cheatsheet 14 — Arrays and Maps
Cheatsheet: arrays, arrayJoin, map, JSON funcs.
ClickHouse Cheatsheet 15 — String Functions
Cheatsheet: string ops, regex, parsing.
ClickHouse Cheatsheet 16 — Best Practices
Cheatsheet: dos and don’ts.
ClickHouse Cheatsheet 17 — Integration Patterns
Cheatsheet: clients, BI tools, ETL.
ClickHouse Cheatsheet 18 — Use Cases
Cheatsheet: ClickHouse use cases by domain.
ClickHouse Cheatsheet 19 — Common Pitfalls
Cheatsheet: common pitfalls.
ClickHouse Cheatsheet 20 — Production Setup
Cheatsheet: prod CH setup with replication, monitoring.