Skip to main content

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
  • Query-level settings

The main distinction between global server settings and query-level settings is that global server settings must be set in configuration files, while query-level settings can be set in configuration files or with SQL queries.

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

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

See non-default settings

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

SELECT name, value FROM system.settings WHERE changed

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:

SELECT name, value FROM system.settings WHERE name = 'max_threads'

This command should return something like:

┌─name────────┬─value─────┐
│ max_threads │ 'auto(8)' │
└─────────────┴───────────┘

1 row in set. Elapsed: 0.002 sec.