Skip to main content
Skip to main content
Edit this page

Settings 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.

Read about global server settings to learn more about configuring your ClickHouse server at the global server level.

Read about session settings to learn more about configuring your ClickHouse server at the session level.

See non-default settings​

To view which settings have been changed from their default value:

If you haven't changed any settings from their default value, then ClickHouse will return nothing.

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

This command should return something like: