Bolt, a prominent ride-hailing app, uses ksqlDB in its data warehouse stream processing pipeline to synchronize and replicate data from various sources for analysis and decision-making. The system allows data from transactional databases, mobile applications, and other external integrations to be centralized, facilitating easy access for analysts and decision-makers to query, compare, and predict across different business lines and time periods. ksqlDB, chosen for its seamless integration with the Kafka ecosystem, enables efficient data replication by creating streams that transform raw data from source topics to destination topics for ingestion into the data warehouse. Built on Kafka consumer and producer protocols, ksqlDB supports horizontal scaling and offers functionalities like data filtering, stream merging, and distribution, eliminating the need for new Java-based Kafka Streams applications. This approach has allowed Bolt to replicate over 500 topics to its warehouse, with plans to explore stateful stream processing in the future.