v.23.12Improvement

PR for Enhanced S3-Link Handling Without Default Region Specification

This PR allows users to use s3-style links (https:// and s3://) without mentioning region if it's not default. Also find the correct region if the user mentioned the wrong one. #58148 (Yarik Briukhovetskyi).
ClickHouse now supports using S3-style links (https:// and s3://) without requiring the region to be specified if it is not the default. Additionally, the system can detect and correct the region if the user provides an incorrect one.

Why it matters

This feature improves user experience and robustness by eliminating the need to explicitly mention the S3 region when it is not the default, reducing configuration errors. It also automatically finds the correct region if the specified one is wrong, preventing connection failures and simplifying S3 integration.

How to use it

Users can specify S3 URLs in their queries or configurations using either https:// or s3:// schemes without including the region parameter. ClickHouse will handle region detection automatically and correct any incorrect region specifications.