PayJoy Cuts Snowflake Data Warehousing Costs by 21% with Keebo


PayJoy’s analytics team and data engineers now have the time they need to fully support their internal business partners because Keebo automated all of their data warehouse optimizations and slashed Snowflake costs by 21%.
“I’m confident Keebo will deliver every possible cost saving, which frees me to support our internal business partners,” says Trish Pham, Head of Analytics, PayJoy. “We never felt good about spending too little time on the manual optimizations and letting costs get out of control, or spending so much time on optimization that we neglected our internal business partners.”
Keebo takes care of the things that I don’t want to think about or deal with. It requires no work on my end. Even if I loved manual optimization, I couldn’t possibly ”achieve what Keebo achieves automatically.
TRISH PHAM
HEAD OF ANALYTICS, PAYJOY
SIGNIFICANT SAVINGS WITHIN 48 HOURS
As PayJoy’s rapid growth drove a 37% increase in Snowflake usage, from 1.6 million to 2 million queries, manually optimizing queries, pipelines and data usage simply wasn’t an option. PayJoy turned to Keebo for platform-independent, automated warehouse optimization and within 48 hours, data warehousing costs had already dropped significantly.
“The biggest thing I love about Keebo is how easy and hands-off it is to use and the fact it takes care of the things that I don’t want to think about or deal with,” says Trish. “Keebo requires no work on my end, and even if I loved manual optimization, I couldn’t possibly achieve what Keebo achieves automatically.”
REALLOCATE VALUABLE ENGINEERING TIME
To deliver significant and ongoing cost reductions, Keebo analyzes the queries and the underlying data automatically to learn usage patterns, without requiring the users or database administrators to provide hints or custom configurations. It also detects data updates and reacts to workload changes automatically.
Keebo frees up hundreds of hours of valuable engineering time that would otherwise be spent on tedious performance optimization tasks. PayJoy on-boarded their warehouses in less than 30 minutes without requiring any changes to their existing applications. As soon as Keebo connected to their data warehouse, it automatically learned a set of “smart models” by analyzing the workload, including warehouse settings, database schema, data distribution, and query patterns. This Data Learning process considers multiple factors before deciding which optimizations will be the most effective. Keebo’s fully automated process determines and applies optimizations without user assistance or manual intervention.
Keebo was a no-brainer decision.
TRISH PHAM
HEAD OF ANALYTICS, PAYJOY
Keebo continuously monitors the cost and performance of the incoming queries and adjusts its optimizations accordingly to account for any workload changes. Optimizations that are no longer beneficial are automatically retired, and new ones are created to accommodate the additional load.
“With Keebo, I log in for a few minutes every few weeks just to see what Keebo is saving us,” says Trish. “Before Keebo, I spent hours on manual optimizations every week. Keebo really freed up my time which is a great bonus on top of the cloud warehousing bill reductions.”
When discussing new solutions, Trish’s manager always asks, “Is it helpful? Do you really need it?”
And for both Trish and her manager, “Keebo was just a no-brainer decision.”
I log in for a few minutes every few weeks just to see what Keebo is saving us. Before Keebo, I spent hours on manual optimizations every week. Keebo really freed up my time.
TRISH PHAM
HEAD OF ANALYTICS, PAYJOY