Add new parameter to S3 table engine

Why it matters

This feature enables users to optimize data storage costs by specifying AWS Intelligent-Tiering storage classes directly within ClickHouse. It supports both key-value and positional (deprecated) parameter formats, providing flexibility and compatibility for managing S3 data storage more efficiently.

How to use it

When creating a table with the S3 table engine or using the s3 table function, specify the storage_class_name parameter in the key-value format to set the desired AWS storage class, for example:

CREATE TABLE example_s3_table (
    ...
) ENGINE = S3(
    ...,
    storage_class_name = 'INTELLIGENT_TIERING'
);

Alternatively, the positional parameter format is still supported but deprecated and should be avoided in new configurations.