v.25.11Improvement

Make S3Queue respect disable_insertion_and_mutation server setting

Make S3Queue respect disable_insertion_and_mutation server setting. #89048 (Raúl Marín).
The S3Queue storage now respects the disable_insertion_and_mutation server setting, preventing data insertions and mutations when this setting is enabled.

Why it matters

This feature ensures consistent enforcement of the disable_insertion_and_mutation server setting across all storage engines, including S3Queue. It prevents accidental data modifications in environments where insertions and mutations should be disabled, enhancing data safety and operational control.

How to use it

Enable the disable_insertion_and_mutation server setting in your ClickHouse server configuration or at runtime. When this setting is active, any attempts to insert or mutate data in S3Queue tables will be rejected automatically.