Data formats
Examples for importing from and exporting to various data formats, including CSV and TSV, Parquet, JSON, binary formats, SQL dumps, and templates with regular expressions.
Data modelling
Guides on data modelling in ClickHouse, including schema design, sparse primary indexes, denormalization, backfilling data, and data compression.
Performance & monitoring
Guides for optimizing query performance, understanding the analyzer, and dynamic column selection.
Aggregate combinator examples
Examples of using aggregate function combinators such as
-If, -Map, -SimpleState, -State, -Merge, -Resample, -Array, and -ForEach.Self-managed upgrade
A guide on upgrading a self-managed ClickHouse installation, including upgrade paths and version compatibility considerations.
OSS best practices
Sizing and hardware recommendations and usage recommendations for open-source ClickHouse.
Deployment and scaling
Deployment guides with examples of deploying ClickHouse for scaling and/or fault tolerance, including ClickHouse Keeper configuration and monitoring.