Data formats
Working with CSV, Parquet, Arrow, Avro, JSON, SQL, binary, and template/regex formats.
Data modelling
Schema design, primary indexes, denormalization, backfilling, compression, and working with arrays/joins.
Performance & monitoring
Query optimization, the analyzer, and techniques for understanding query execution.
Aggregate combinator examples
Worked examples of every aggregate-function combinator (
-If, -Map, -Array, -State, -Merge, -Resample, etc.).Self-managed upgrade
Upgrade procedure for self-managed ClickHouse deployments.
OSS best practices
Sizing, hardware recommendations, and operational tips for running ClickHouse OSS.
Deployment and scaling
Replication, sharding, Keeper, monitoring, and end-to-end deployment examples.