v.21.9New Feature

Added Support for Custom Query in Multiple Database Sources

Added support for custom query for MySQL, PostgreSQL, ClickHouse, JDBC, Cassandra dictionary source. Closes #1270. #26995 (Maksim Kita).
Added support for custom query definitions in dictionary sources for MySQL, PostgreSQL, ClickHouse, JDBC, and Cassandra.

Why it matters

This feature allows users to define custom queries when creating dictionary sources from external databases or data storages, enabling more flexible and precise data extraction tailored to specific needs. It solves the limitation of fixed query structures by letting users customize data retrieval logic for dictionary population.

How to use it

Users can specify their own SQL or query string in the dictionary source configuration under the query parameter for supported types such as MySQL, PostgreSQL, ClickHouse, JDBC, and Cassandra. This custom query will be used to fetch data for the dictionary.