v.20.3New Feature

Added S3 Storage and Table Function Support for Globs/Wildcards

Added support for globs/wildcards for S3 storage and table function. #8851 (Vladimir Chebotarev)
Added support for using glob patterns and wildcards in S3 storage paths and the corresponding table function.

Why it matters

This feature allows users to specify multiple files or objects in S3 storage using glob syntax, simplifying data selection and management by enabling pattern-based retrieval instead of listing individual file paths.

How to use it

Users can now use glob patterns (like *.csv or data_2023-??-??.json) in S3 URI paths when defining external tables or using the S3 table function. For example, in SQL, specify the S3 path with wildcards inside the table function to query multiple matching files at once.