v.21.6Improvement
Added region parameter for S3 storage and disk
Added region parameter for S3 storage and disk. #23846 (Vladimir Chebotarev).Why it matters
This feature allows users to specify the AWS region when configuring S3 storage and disks in ClickHouse, ensuring correct and optimized interaction with region-specific S3 endpoints. It solves issues related to connectivity and latency by directing requests to the appropriate regional S3 service.How to use it
When configuring an S3 storage or disk, include theregion parameter in the settings to specify the AWS region, for example:WITH s3('https://s3.amazonaws.com', 'access_key', 'secret_key', 'bucket', 'region') AS s3_table
SELECT * FROM s3_table;Or in the configuration XML for disks:
<disk name="s3_disk" type="s3">
<endpoint>https://s3.amazonaws.com</endpoint>
<access_key_id>your_access_key</access_key_id>
<secret_access_key>your_secret_key</secret_access_key>
<bucket>your_bucket</bucket>
<region>your_region</region>
</disk>