Support for partitioned writes in S3 table function

Why it matters

This feature enables users to write data into s3 storage in a partitioned manner, improving organization and management of large datasets stored in S3. It allows for efficient data writes that align with partitioning schemes, which can optimize subsequent data processing and retrieval.

How to use it

Users can leverage partitioned writes by using the s3 table function with appropriate partitioning expressions in their INSERT statements. This typically involves specifying partition columns in the query to direct data into corresponding partitions within the S3 storage layout.