[JosephRedfern]

It's linked to at the end, but I'm surprised that this article didn't feature/mention ClickHouse's own write-up of this undertaking. Part 1 here: https://clickhouse.com/blog/building-a-data-warehouse-with-c..., part 2 here: https://clickhouse.com/blog/building-a-data-warehouse-with-c....

Aspects of the post seem to borrow quite heavily from the original write-ups, which are worth a read.