v.23.8Improvement

Fix s3 table function compatibility with pre-signed URLs

Fix the case when s3 table function refused to work with pre-signed URLs. close #50846. #52310 (chen).
Fixed an issue where the s3 table function did not work properly with pre-signed URLs.

Why it matters

This fix resolves the problem that prevented users from accessing data stored in S3 buckets using pre-signed URLs through the s3 table function. It enables seamless querying of S3 data secured by temporary and signed access links, improving compatibility and ease of use.

How to use it

Users can now use the s3 table function with pre-signed URLs directly without encountering errors. Simply pass the pre-signed URL as the source argument in the s3 table function as done for regular S3 URLs.