How We Refresh Razorpay's Data Warehouse 10x Faster with Graphs and Indexes

2026-07-16

Razorpay reduced data warehouse refresh time by 90% by switching from full table scans to incremental graph traversal. This involves a silver layer for deduplicating daily changes, secondary indexes for join columns and partition metadata, and graph traversal to process only changed rows while enriching updates via dependency back-traversal.