Dictionary

A dictionary in ClickHouse provides an in-memory key-value representation of data from various internal and external sources, optimizing for super-low latency lookup queries.

Dictionaries are useful for:

• Improving the performance of queries, especially when used with JOINs
• Enriching ingested data on the fly without slowing down the ingestion process