We did a deep-dive comparison between Redshift and ClickHouse Cloud for analytics workloads at scale: https://clickhouse.com/blog/redshift-vs-clickhouse-compariso...

It's fairly technical and goes into details but overall it displayed how to achieve increased compression and query performance