I spent 5 hours learning how ClickHouse built their internal data warehouse (opens in new tab)

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.

Looks to me close to typical DWH setup like many large corporations have, except for the ClickHouse specific settings and Docker usage (most DEs seem to be skeptical of anything that isn't SQL in my experience)

If you built this out of AWS managed services what would you use?

Your drawings, on the blog, are really nice, which tools did you use to make those?