v.23.5Improvement

Allow Default Loading of Dictionaries and Functions from YAML

Allow loading dictionaries and functions from YAML by default. In previous versions, it required editing the dictionaries_config or user_defined_executable_functions_config in the configuration file, as they expected *.xml files. #49812 (Alexey Milovidov).
ClickHouse now supports loading dictionaries and user-defined functions directly from YAML files by default, removing the previous limitation of requiring XML configuration.

Why it matters

This feature simplifies the configuration process by allowing users to define dictionaries and functions using YAML format, which is often easier to read and write compared to XML. It enhances usability and reduces the need for manual configuration file edits when adding or modifying dictionaries and functions.

How to use it

Users can now provide dictionary and function definitions using YAML files without modifying the dictionaries_config or user_defined_executable_functions_config sections of the configuration. Simply place YAML files in the appropriate directory, and ClickHouse will load them automatically.