v.24.12Improvement

Server Config Settings Now Apply to Client

Official CH changelog text
Settings from server config (users.xml) now apply on the client too. Useful for format settings, e.g. date_time_output_format. #71178 (Michael Kolupaev).
Settings defined in the server configuration file (users.xml) are now also applied on the client side, enabling consistent configuration such as format settings like date_time_output_format.

Why it matters

This feature addresses the problem of configuration inconsistency between the server and client. By applying server config settings on the client, users benefit from unified and predictable behavior, especially for output formatting and other settings dependent on configuration.

How to use it

Define the desired settings in the users.xml server configuration file as usual. These settings will automatically apply when using the ClickHouse client, requiring no additional client-side setup.

Related resources

PreviousNext