Explore the world of open-source real-time data warehouses in this 51-minute Linux Foundation conference talk. Delve into the unique characteristics of analytic applications and SQL data warehouses, with a focus on ClickHouse and its Merge Tree table engine. Discover the intricacies of data layout, storage optimization, and parallelized execution. Learn about materialized views, tiered storage, and distributed queries. Examine patterns for Kafka-based ingestion pipelines, Grafana visualization, and operation on Kubernetes. Gain insights into breaking free from proprietary solutions and leveraging open-source technologies for efficient data warehousing and analytics.