Skip to content
ClickHouse Docs

compatibility_* session settings

Autogenerated from ClickHouse system tables

These settings are available in system.settings and are autogenerated from the ClickHouse snapshot.

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.

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.