Case Study Deskcasestudydesk.com
Home ConstructionSourced

Case Study: Toll Brothers cuts new-source onboarding from weeks to under a day with Coalesce on Snowflake

Toll Brothers Case StudySourced & dated by Case Study Desk
Key facts · TL;DR
Company
Toll Brothers
Industry
Home Construction
Challenge
Manual ETL and long queues slowed analytics delivery
Headline result
Weeks to under a day for new-source onboarding

Key results

<1 day
New-source onboarding to silver layer
from weeks or months
65+
Objects relabeled in under an hour
EnterpriseOne fields via Coalesce macros
100M+
Row ERP tables on incremental processing
replacing truncate-and-reload

The challenge

Toll Brothers, America's largest luxury homebuilder, builds across more than 30 U.S. markets with a 5,500-person organization. Critical metrics were generated across Oracle EnterpriseOne, Salesforce, Workday, and Hyphen BuildPro, and manual ETL and long delivery queues slowed analytics delivery.

The solution

The company centralized data in Snowflake and standardized transformation and governance with Coalesce Transform and Coalesce Catalog, adopting incremental processing and standardized bronze-silver-gold (medallion) pipelines.

The results, in context

Toll Brothers reduced the time to ingest a new cloud source and model it to the silver layer from weeks or months to less than a day. Using Coalesce macros and the Oracle EnterpriseOne data dictionary, the team bulk relabeled more than 65 cryptic-field objects in under an hour, and moved 100M+ row ERP tables to incremental processing for higher reliability.

Products used

Coalesce TransformCoalesce Catalog