Case Study: Stern Risk Partners cuts dbt runtime from 2 hours to 7 minutes with MotherDuck

A MotherDuck Case Study

Preview of the Stern Risk Partners Case Study

Stern Risk Partners cuts dbt runtime from 2 hours to 7 minutes with MotherDuck

Stern Risk Partners, an insurance brokerage, faced a performance crisis as their single Heroku Postgres database buckled under the strain of their growing data workloads. Their ETL jobs and dbt transformations took hours to complete, locking the database and preventing users from accessing their application. They needed a new solution to handle their analytical processing and turned to MotherDuck for its data platform.

By migrating to MotherDuck, Stern Risk Partners implemented a new architecture where dbt transformations were completed in just 7 minutes instead of 2 hours. MotherDuck's platform provided the performance and simplicity they needed, eliminating the management overhead of other solutions. This cut transformation times dramatically and unlocked the ability to deploy embedded analytics for their customers, setting them on a path to self-service querying.


View this case study…

MotherDuck

19 Case Studies