Two (completely different) types of dbt incremental models in BigQuery

Partition-based loading or tracking the history of your downstream model with incremental loads

Incremental models in dbt are not a new invention, they are the traditional way of appending data into a table. In old-school datawarehouses, this would be the way to bring the daily data to your data storage environment. In order for things not to get out of control, you would put a key and decide to update the row if it …

bigquery data engineering data management data warehouse dbt incremental types