v.21.2Improvements

Table function S3 defaults to global region when region is indeterminate

Official CH changelog text
Table function S3 will use global region if the region can't be determined exactly. This closes #10998. #19750 (Vladimir Chebotarev).
The S3 table function in ClickHouse now defaults to using the global region when the exact AWS region cannot be determined.

Why it matters

This feature addresses the issue where the S3 table function could fail or behave unexpectedly if the AWS region was unclear. By falling back to the global region, it improves reliability and usability when accessing S3 data without explicitly specifying a region.

How to use it

Use the S3 table function as usual in your queries. When the region parameter is not precisely specified or cannot be detected, ClickHouse will automatically use the global region to access S3 resources.

Related resources

PreviousNext