“Just OLAP it”: How Ramp rebuilt its analytics platform on ClickHouse Cloud

Ramp's transition to ClickHouse Cloud has significantly enhanced its ability to provide real-time, customer-facing analytics, particularly for large enterprise clients. Initially struggling with Postgres' limitations in handling vast transaction data, Ramp adopted ClickHouse to achieve millisecond query responses, a stark improvement from the previous 40-second delays. By implementing a Postgres-to-Kafka-to-ClickHouse pipeline, Ramp's engineers, led by Director of Engineering Ryan Delgado, developed a robust OLAP platform that supports advanced features like AI-powered spend insights and proactive budget controls. This shift not only resolved existing performance bottlenecks but also positioned ClickHouse as a cornerstone of Ramp’s analytics infrastructure, enabling sophisticated forecasting and spend management tools for over 50,000 customers. Looking forward, Ramp aims to expand its OLAP capabilities to encompass a broader range of data types, thereby continuing to scale its analytics offerings.