S3 Configuration for Cold Storage and Query Results

TLDR Amir asked about query results when using S3 for cold storage. Srikanth confirmed it's possible with a performance hit, as metadata is kept on disk for reference.

Photo of Amir
Tue, 14 Mar 2023 10:23:49 UTC

Hi guys, a question regarding S3 configuration for cold storage - will I be able to get query results from S3 when it is configured? If not, how can I run queries on the offloaded data. Thanks!

Photo of Srikanth
Tue, 14 Mar 2023 11:58:20 UTC

You should be able to get the query results but with some hit to performance. ClickHouse keeps a metadata for s3 objects on the disk and fetches info when needed.

Photo of Amir
Tue, 14 Mar 2023 13:01:09 UTC

Great! thanks!!