4 ms·
I spent 5 hours learning how ClickHouse built their internal data warehouse
- omgwtfusb 2y agoLooks 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)
- JosephRedfern 2y agoIt'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-clickhouse https://clickhouse.com/blog/building-a-data-warehouse-with-c..., part 2 here: https://clickhouse.com/blog/building-a-data-warehouse-with-clickhouse-part-2 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.
- simplegeek 2y agoYour drawings, on the blog, are really nice, which tools did you use to make those?
- putsjoe 2y agoNot 100% but likely to be: https://excalidraw.com/ https://excalidraw.com/
- tlarkworthy 2y agoIf you built this out of AWS managed services what would you use?