v.23.3New Feature

Implement system.server_settings for Server Configurations

Official CH changelog text
Implement system.server_settings (similar to system.settings), which will contain server configurations. #46550 (pufit).
Introduces the system.server_settings table, providing access to server-level configuration settings similar to the existing system.settings table.

Why it matters

This feature enables users to query and inspect ClickHouse server configuration parameters directly from SQL, allowing better visibility and management of server settings without needing to access configuration files or server internals.

How to use it

Users can query the system.server_settings table using standard SQL SELECT statements, for example:

SELECT * FROM system.server_settings;

This will return the current server configuration settings and their values.

Related resources

PreviousNext