v.23.8Improvement

Added s3_storage_class Parameter to BACKUP Statement for S3 Backups

Official CH changelog text
Added possibility to use s3_storage_class parameter in the SETTINGS clause of the BACKUP statement for backups to S3. #52658 (Roman Vasin).
Added support for the s3_storage_class parameter in the SETTINGS clause of the BACKUP statement when performing backups to S3 storage.

Why it matters

This feature allows users to specify the S3 storage class (such as STANDARD, INTELLIGENT_TIERING, or GLACIER) for backup files, enabling cost optimization and better management of backup storage based on access patterns and retention needs.

How to use it

When creating a backup to S3 using the BACKUP statement, include the s3_storage_class parameter in the SETTINGS clause. For example:

BACKUP TABLE your_table TO 's3://bucket/path/'
SETTINGS s3_storage_class = 'INTELLIGENT_TIERING'


Replace your_table, S3 bucket path, and the storage class value as appropriate.

Related resources

PreviousNext