When working with analytical databases, enriching fact tables with customer information, product metadata, geographical mappings, or business attributes is a common requirement. Traditionally, this enrichment is performed using SQL JOINs. While JOINs work well, they can become increasingly expensive as data volumes grow. Every query must repeatedly scan and match rows, adding latency and consuming valuable resources. ClickHouse® offers a powerful alternative: Dictionaries . Dictionaries provide