Case Study Deskcasestudydesk.com
Industrial EquipmentSourced

Case Study: WesTrac cuts dbt-failure recovery 30%+ and saves 36% annually on Astro

WesTrac Case StudySourced & dated by Case Study Desk
Key facts · TL;DR
Company
WesTrac
Industry
Industrial Equipment
Challenge
Azure Data Factory, Databricks Notebooks, and Snowflake Tasks left orchestration gaps
Headline result
WesTrac recovered from dbt job failures 30%+ faster and reported 36% annual savings after orchestrating its Snowflake pipelines on Astro

Key results

30%+
Faster recovery from dbt job failures
36%
Annual savings
From optimized job execution
25%
Infrastructure-management time savings

The challenge

WesTrac is Australia's largest authorized Caterpillar dealer. Consolidating on Snowflake exposed orchestration gaps: Azure Data Factory lacked flexibility for complex dependencies, Databricks Notebooks produced brittle code, and Snowflake Tasks could not easily trigger external jobs like dbt.

The solution

WesTrac implemented Astronomer's managed Airflow service (Astro) to orchestrate its entire pipeline from ingestion through reporting.

Astronomer instantly became the conductor of our data orchestra, pulling all the moving parts together.

CH
Chris Hidding
Head of Digital, WesTrac

The results, in context

On Astro, WesTrac reported recovering from dbt job failures more than 30% faster by re-running only the failed model, along with 36% annual savings from optimized job execution and 25% savings in infrastructure-management time.

Products used

Astronomer AstroAstronomer Apache Airflow