Schema design

ClickHouse® limitations

How much is too much?

ClickHouse® row-level deduplication

ClickHouse® row-level deduplication.

Column backfilling with alter/update using a dictionary

Functions to count uniqs

Functions to count uniqs.

How to change ORDER BY

How to change ORDER BY.

Ingestion of AggregateFunction

ClickHouse® - How to insert AggregateFunction data

Insert Deduplication / Insert Idempotency

Using ClickHouse® features to avoid duplicate data

JSONEachRow, Tuples, Maps and Materialized Views

How to use Tuple() and Map() with nested JSON messages in MVs

Pre-Aggregation approaches

ETL vs Materialized Views vs Projections in ClickHouse®

SnowflakeID for Efficient Primary Keys

Two columns indexing

How to create ORDER BY suitable for filtering over two different columns in two different queries

Best schema for storing many metrics registered from the single source

Codecs

Dictionaries vs LowCardinality

Flattened table

Floats vs Decimals

Ingestion performance and formats

IPs/masks

JSONAsString and Mat. View as JSON parser

LowCardinality

ClickHouse® Materialized Views

Making the most of this powerful ClickHouse® feature