Skip to main content
These settings are available in system.settings and are autogenerated from source.

​
dictionary_lazy_load

Controls loading of a dictionary when specified in the SETTINGS clause of CREATE DICTIONARY: 1 defers loading until first use, 0 loads the dictionary at creation, 'auto' follows the server setting dictionaries_lazy_load. Has no effect when set on a session or query level.

​
dictionary_use_async_executor

Execute a pipeline for reading dictionary source in several threads. It’s supported only by dictionaries with local CLICKHOUSE source.

​
dictionary_validate_primary_key_type

Validate primary key type for dictionaries. By default id type for simple layouts will be implicitly converted to UInt64.
Last modified on July 22, 2026