Docs

ByteHouse Cloud Data Warehouse Version

System tables

system.settings

The System table system.settings contains the current system settings and their values, including setting name, value, modification privilege, and other key information. It can be used to view the current configuration and troubleshoot parameter-related problems.

Column names

| | | | \

Name	Data type	Description
			\
name	String	The name of the system setting.
			\
value	String	The current value of the setting.
			\
changed	UInt8	Whether the setting deviates from the default value.
			\
description	String	Description of the setting's function.
			\
min	String	Can be empty. The minimum value of the setting. If there is a minimum value, it is set by constraint. If the setting does not have a minimum value, it contains NULL.
			\
max	String	Can be empty. The maximum value of the setting. If there is a maximum value, it is set by constraint. If the setting does not have a maximum value, it contains NULL.
			\
readonly	UInt8	Whether the current user can modify the setting:	\
			\
		* 0 — The current user can modify this setting.	\
		* 1 — The current user cannot modify this setting.
			\
type	String	The data type of the setting.

Example

Filter settings that can be modified:

SELECT 
  name, 
  value, 
  type 
FROM system.settings 
WHERE readonly = 0 
LIMIT 10;

Query results example:

Last updated: 2026.03.31 16:16:45

ByteHouse Cloud Data Warehouse Version

Column names #

Example #

Column names

Example