Epilot, an energy sector SaaS platform, faced challenges with its existing data infrastructure as it scaled. The company initially used AWS Redshift and S3 for data storage and processing but experienced limitations in performance and real-time analytics. To address these issues, epilot switched to ClickHouse as their central data storage layer, offering improved performance, scalability, cost efficiency, and flexibility. The implementation of ClickHouse led to significant improvements in query performance, real-time analytics, and data consolidation, enabling better service delivery and customer insights. Looking ahead, epilot plans to expand its use of ClickHouse further, leveraging it for AI and machine learning applications as part of their future growth strategy.