v.19.16Improvement
Made Setting S3_min_upload_part_size Table-level
Made setting s3_min_upload_part_size table-level. #7059 (Vladimir Chebotarev)Why it matters
This feature allows users to specify the minimum upload part size for S3 multipart uploads individually for each table, providing more granular control over S3 data ingestion performance and cost optimization.How to use it
Set thes3_min_upload_part_size parameter in the table creation or alteration query using the SETTINGS clause. For example:CREATE TABLE s3_table (
...
) ENGINE = S3('s3://bucket/path', 'access_key_id', 'secret_access_key', 'region')
SETTINGS s3_min_upload_part_size = 10485760;or
ALTER TABLE s3_table
MODIFY SETTING s3_min_upload_part_size = 10485760;