Introduction of the Dictionary Database Engine in ClickHouse, which enables automatic availability of dictionary tables for all connected external dictionaries within a database context.
Why it matters
This feature was created to simplify the management and querying of external dictionaries by exposing them as tables in a dedicated dictionary database engine. It solves the issue of manually handling dictionary tables individually by providing an integrated and consistent interface, improving usability, and making dictionary data easily accessible using SQL queries.How to use it
To use the Dictionary Database Engine, configure the dictionary database in your ClickHouse server configuration file or via SQL by specifying the dictionary engine. Once the dictionary database is created and connected to external dictionary sources, dictionary tables become automatically available for use in SQL queries. You can query these dictionary tables like regular tables without additional manual setup for each dictionary.