June 2024 Newsletter

The June ClickHouse newsletter highlights recent developments in real-time data warehouses. Key points include the introduction of the Dynamic type in the 24.5 release, performance improvements for CROSS JOINs, and functionality to read into archive files on S3. Michael Shi from HyperDX explains why they chose ClickHouse over Elasticsearch for observability data, citing its columnar data layout and sparse indexes as key differentiators. Tom Weisner provides a tutorial on using Python User-Defined functions in ClickHouse, while Atheer Alabdullatif from Tweeq discusses their choice of ClickHouse and other tools for their data platform. The newsletter also covers the use of ClickHouse to count unique users at scale and its role in ETL/ELT processes.