v.23.9Improvement

Add S3 Credential Support via SSO with AWS_PROFILE Variable

Official CH changelog text
Add support for S3 credentials using SSO. To define a profile to be used with SSO, set AWS_PROFILE environment variable. #54347 (Antonio Andelic).
Add support for using AWS SSO credentials with S3 in ClickHouse by allowing the specification of an AWS_PROFILE environment variable.

Why it matters

This feature enables ClickHouse users to authenticate to AWS S3 using AWS Single Sign-On (SSO) credentials, simplifying secure access management and eliminating the need for static access keys.

How to use it

Set the environment variable AWS_PROFILE to the desired AWS profile configured for SSO before running ClickHouse. This profile will then be used for AWS S3 authentication.

Related resources

PreviousNext