Like S3 for cost efficiency

So you can store logs for certain days in hot storage i.e clickhouse and then it can be moved to S3. Is that what you are asking?

Yes

Can be like loki , entire backend can be on s3.

We are using clickhouse for fast query performance and good compression. We don’t support s3 directly, but you can move data to s3 as soon as you want from clickhouse while compromising on query performance. Though recommendation will be to store the most frequent data on clickhouse for example 1 day and then move to s3.

What is clickhouse backend?

Yes EBS.

Ok

But it can query data present in S3, but as mentioned it will be slower.

Or its up to is

It upto the user to configure retention period.

Means clickhouse can query data presented in s3

Correct.

That's nice

yeah, ebs is better than elasticsearch :)