v.22.2Improvement

Allow s3 function with explicit credentials in ClickHouse

Allow to write s3(url, access_key_id, secret_access_key) (autodetect of data format and table structure, but with explicit credentials). #34503 (Kruglov Pavel).
Added support for writing data to S3 using explicit credentials via s3(url, access_key_id, secret_access_key) format with autodetection of data format and table structure.

Why it matters

This feature enables users to write data directly to Amazon S3 by specifying explicit access credentials. It solves the problem of credential management by allowing secure authentication and simplifies data ingestion workflows with automatic detection of data format and table schema.

How to use it

Use the s3 function with the syntax s3(url, access_key_id, secret_access_key) in your INSERT INTO or similar commands. The system will automatically detect the data format and table structure based on the target S3 location.