CODEWITHSUNDEEP
snapshotdbtscd2
user136079
user136079

Reputation: 1

dbt snapshots - backfill

We are building a dimension table whose columns do not update very frequently - less than 0.1% of records change on a daily basis. we are thinking about using dbt snapshots. Is dbt snapshot the right strategy? According to the dbt snapshot page, we should avoid using joins. However, this table will have a join and will also involve business logic to calculate some fields. How does backfill work for dbt snapshots?

Initially, we built an incremental table, but that ended up having too many rows. Is dbt snapshot the right strategy?

Upvotes: 0

Views: 1319

Answers (0)

Related Questions