Skip to main content
These settings are available in system.settings and are autogenerated from source.

​
compatibility

The compatibility setting causes ClickHouse to use the default settings of a previous version of ClickHouse, with exceptions recorded in the settings changes history. If settings are set to non-default values, then those settings are honored (only settings that have not been modified are affected by the compatibility setting). Changes marked Ignore in system.settings_changes block rollback of that change and all earlier changes to the same setting. This setting takes a ClickHouse version number as a string, like 22.3, 22.8. An empty value means that this setting is disabled. Disabled by default.
In ClickHouse Cloud, the service-level default compatibility setting must be set by ClickHouse Cloud support. Please open a case to have it set. However, the compatibility setting can be overridden at the user, role, profile, query, or session level using standard ClickHouse setting mechanisms such as SET compatibility = '22.3' in a session or SETTINGS compatibility = '22.3' in a query.

​
compatibility_s3_presigned_url_query_in_path

Compatibility: when enabled, folds pre-signed URL query parameters (e.g. X-Amz-*) into the S3 key (legacy behavior), so ’?’ acts as a wildcard in the path. When disabled (default), pre-signed URL query parameters are kept in the URL query to avoid interpreting ’?’ as a wildcard.
Last modified on September 15, 2026