Schema design

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 much is too much?

ClickHouse Limitations.

How to change ORDER BY

How to change ORDER BY.

Insert Deduplication / Insert idempotency

Insert Deduplication / Insert idempotency , insert_deduplicate setting.

Pre-Aggregation approaches

ETL vs Materialized Views vs Projections in ClickHouse.

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

MATERIALIZED VIEWS