dbt.htm

Dbt Notes

Incremental models:

They need:

• a filter to select just the new or updated records
• a conditional block that wraps our filter and only applies it when we want it
• configuration that tells dbt we want to build incrementally and helps apply the conditional filter when needed

select * from orders

where
  updated_at > (select max(updated_at) from