Hmm seems odd? Currently I have none but will probably add a TTL to clickhouse on 5 years.

And if you really need to prune data you could just use good ol SQL?