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)
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.