「世代を超えた飛躍」: Trio が ClickHouse Cloud で決済分析を統合し、ストレージを 88% 削減した方法

Trio, a Brazilian fintech company, leverages ClickHouse as its single source of truth for payment processing, compliance reporting, and both operational and customer dashboards, achieving significant storage reduction and high-speed processing with minimal tuning. Handling over 243 million payments in the first half of 2025 and processing over a billion events daily, Trio has integrated ClickHouse to transform its scattered systems into a cohesive analytics platform, ensuring data accuracy and compliance in a highly regulated financial environment. The architecture employs a custom ETL solution and sliding window techniques using refreshable materialized views and ReplacingMergeTree to manage delayed, duplicated, and unordered events effectively. This setup has enabled Trio to maintain accurate, real-time financial analytics while significantly reducing storage needs and enhancing processing speed, allowing the team to focus more on data analysis rather than system limitations. As they continue to refine their system, Trio plans to incorporate recent ClickHouse advancements, aiming for a more sophisticated, reliable, and easy-to-manage analytics infrastructure.