Trials and Tribulations of Incremental Models

on Oct 21, 2024
Incremental models are core to dbt, and are a key solution to how data teams balance the need for computationally efficient and timeline data.
This talk will discuss some challenges with building incremental models at scale, and how our approach has evolved over time in a high growth company with over 30 third party sources of data. On a technical level, this will cover the is_incremental()
SQL block logic, as well as custom materializations that make building models simpler and more efficient.
Published on: Oct 29, 2021
Rewrite the future of data work, only at Coalesce
Coalesce is where data teams come together. Join us October 13-16, 2025 and be a part of the change in how we do data.
Set your organization up for success. Read the business case guide to accelerate time to value with dbt.
VS Code Extension
The free dbt VS Code extension is the best way to develop locally in dbt.