v.19.16New Feature

Support Redis as Source of External Dictionary

Support Redis as source of external dictionary. #4361 #6962 (comunodi, Anton Popov)
Added support for Redis as a source of external dictionaries in ClickHouse, enabling seamless integration with Redis data.

Why it matters

This feature allows users to directly use Redis key-value stores as external dictionaries in ClickHouse, facilitating real-time and efficient data lookups from Redis without complex ETL processes, thereby improving performance and data integration workflows.

How to use it

To use Redis as a source for an external dictionary, define a dictionary configuration in XML or via the dictionary definition that specifies Redis as the source type and provides connection details (host, port, database, password). Then, refer to the dictionary in your queries for lookups. For example, specify redis as source type and set parameters like host, port, and db.