Skip to main content
Skip to main content
Edit this page

Settings Overview

Overview

note

XML-based Settings Profiles and configuration files are currently not supported for ClickHouse Cloud. To specify settings for your ClickHouse Cloud service, you must use SQL-driven Settings Profiles.

There are two main groups of ClickHouse settings:

  • Global server settings
  • Session settings

The main distinction between both is that global server settings apply globally for the ClickHouse server, while session settings apply to user sessions or even individual queries.

Viewing non-default settings

To view which settings have been changed from their default value you can query the system.settings table:

If no settings have been changed from their default value, then ClickHouse will return nothing.

To check the value of a particular setting, you can specify the name of the setting in your query:

Which will return something like this:

Further reading

  • See global server settings to learn more about configuring your ClickHouse server at the global server level.
  • See session settings to learn more about configuring your ClickHouse server at the session level.