Company
Date Published
Author
ClickHouse Editor
Word count
989
Language
English
Hacker News points
None

Summary

The WebXT team from Microsoft presented two of their analytics products, Titan and Microsoft Clarity, using ClickHouse at a community meetup on January 18th, 2023. The team showcased how they can analyze petabytes of data in seconds and create custom dashboards with just a few clicks, thanks to the high-performance capabilities of ClickHouse. The key goal for Titan was to provide self-service analytics with response times within seconds, allowing employees to interactively slice and dice data and save it as dashboards. The team chose ClickHouse as the data engine due to its speed, cost-effectiveness, and inbuilt telemetry features, which made monitoring data usage and storage more accessible. The presentation also covered optimization techniques for ClickHouse, including a near real-time pipeline and query optimizers, which resulted in significant improvements in query performance. Overall, the event highlighted the importance of self-serve analytics in Microsoft's success and demonstrated how ClickHouse can support such initiatives.