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, where the previous version is provided as the setting.
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).
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
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.12 | 0 | New setting. |
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.