For us, a significant reason was the ClickHouse cloud-hosted offering, rather than having to manage a cluster ourselves. Their use of S3 as the backing storage medium means that large-scale data retention is quite affordable.
A good comparison we've referenced: https://leventov.medium.com/comparison-of-the-open-source-ol...