v.25.8New Feature

Allow key value arguments in s3 or

Allow key value arguments in s3 or s3Cluster table engine/function, e.g. for example s3('url', CSV, structure = 'a Int32', compression_method = 'gzip'). #85134 (Kseniia Sumarokova).
Added support for key-value arguments in the s3 and s3Cluster table engines and functions, enabling detailed configuration such as specifying structure and compression method directly.

Why it matters

This feature allows users to pass additional parameters as key-value pairs when creating tables or queries with the s3 and s3Cluster engines/functions. By supporting detailed options like structure and compression_method, it improves flexibility and usability, facilitating better control over data parsing and storage from S3 sources.

How to use it

When using the s3 or s3Cluster engine or function, provide additional arguments in a key-value format inside the parentheses. For example:

s3('url', CSV, structure = 'a Int32', compression_method = 'gzip')