v.23.12New Feature

Added readonly setting for S3 disk access in ClickHouse

Official CH changelog text
Added a new setting readonly which can be used to specify an S3 disk is read only. It can be useful to create a table on a disk of s3_plain type, while having read only access to the underlying S3 bucket. #57977 (Pengyuan Bian).
Added a new readonly setting for S3 disks to enable read-only access mode.

Why it matters

This feature allows users to configure an S3 disk as read-only, which is useful when creating tables on s3_plain type disks without granting write access to the underlying S3 bucket. It enhances security and prevents accidental modifications.

How to use it

Set the readonly parameter to true in the configuration of your S3 disk. For example:

disks:
  my_s3_disk:
    type: s3_plain
    endpoint: <endpoint_url>
    readonly: true
    access_key_id: <your_access_key>
    secret_access_key: <your_secret_key>


Then create tables using this disk to have read-only access to the S3 storage.

Related resources

PreviousNext