v.23.2New Feature

Allow Configuring Storage with New Disk Settings in ClickHouse

Official CH changelog text
Allow configuring storage as SETTINGS disk = '<disk_name>' (instead of storage_policy) and with explicit disk creation SETTINGS disk = disk(type=s3, ...). #41976 (Kseniia Sumarokova).
Allow configuring table storage using the SETTINGS disk = '<disk_name>' syntax as an alternative to storage_policy, including support for explicit disk creation with SETTINGS disk = disk(type=s3, ...).

Why it matters

This feature simplifies and enhances the flexibility of table storage configuration by enabling users to specify the storage disk directly via settings instead of relying solely on storage policies. It also allows defining disks explicitly within table settings, such as creating S3 disks on the fly, improving usability and configuration granularity.

How to use it

When creating or altering a table, use the SETTINGS disk = '<disk_name>' clause to specify the storage disk. To create a disk explicitly, use SETTINGS disk = disk(type=s3, ...) with the required disk parameters inside the disk() function.

Related resources

PreviousNext