How to securely query AWS S3 from ClickHouse
ClickHouse is a powerful analytical database, loading data from an AWS S3 bucket allows you to quickly start analyzing the data without having to download and upload them manually in the database. Writing data to S3 allows you to offload some cold data, while keeping all the hot data in ClickHouse and, with the usage of federated queries, being able to query both hot and cold data at the same time.