v.21.6Improvement

Added region parameter for S3 storage and disk

Added region parameter for S3 storage and disk. #23846 (Vladimir Chebotarev).
Added a region parameter for S3 storage and disk in ClickHouse.

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 the region 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>