How to configure incremental models in DBT ?

Incremental Model config Block
  • how to filter the rows on an incremental run.
  • the uniqueness constraint of the model (if any). However, it is optional. When key is not defined, entire record is considered as key.
  • Snowflake: merge (default), delete+insert (optional)
  • BigQuery: merge (default), insert_overwrite (optional)
  • Spark: insert_overwrite (default), merge (optional, Delta-only)

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Arun Singh

Arun Singh

Work as Enterprise Data Architect, Cloud Data Architect and focuses on building data architectures on cloud platforms. www.linkedin.com/in/arun-k-singh-3221372