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