Change Default Setting for wait_dictionaries_load_at_startup to True

Why it matters

This feature ensures that dictionary data is fully loaded during ClickHouse startup by default, improving stability and readiness of queries that depend on dictionary data. It prevents lazy loading conflicts by conditioning the usage of wait_dictionaries_load_at_startup on the dictionaries_lazy_load setting.

How to use it

To use this feature, ensure that dictionaries_lazy_load is set to false. The wait_dictionaries_load_at_startup setting will then default to true, forcing ClickHouse to load dictionaries completely at startup. You can explicitly configure these settings in the server configuration file or via user profile settings.