How dbt State cuts warehouse compute and speeds up every run

dbt State is a state-aware capability designed to reduce warehouse compute costs and accelerate dbt runs by rebuilding only models whose code or upstream data has changed, while skipping or cloning unchanged models from other environments. Evolving from state-aware orchestration, it is available through the dbt platform, dbt Core v2.0, and a plugin for supported v1 releases, allowing use across production, development, CI, and external orchestrators such as Airflow and Dagster. It tracks hashes of model code and data states in a control plane, then determines whether each model must be rebuilt or can be reused; dbt reports average warehouse-compute reductions of about 30%. Pricing is based on unique daily reused models or tests, termed daily active target tables. Fanatics Betting and Gaming used dbt State with Snowflake, dbt, and Airflow to address overscheduling across thousands of models, increasing reuse from roughly 0.2% to 15% after defining source freshness and model-level lag tolerances, with some projects reaching 25% reuse and an overall average near 8%. Beyond savings, the company reported that the approach simplifies operations by shifting scheduling decisions from job cadence and selectors toward explicit model freshness requirements.

No tracked trend matches for this post yet.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.