dbt-labs/dbt-technical-blog-writing

Change data capture on metrics in dbt

Closed this issue · 3 comments

graciegoheen commented

What's your key point?
How to capture version history of a dbt model with both:
a) changing source data
b) changing business logic

Outline solution(s) and the pros/cons & use cases of them.

Current solution ideas:

  • Downstream Incremental Models
  • Upstream Snapshots

Prior art:
Let me know if you've read any prior writing on this topic!

Link to notes / outline / draft:
I have a very rough writeup in the ProServ knowledge repo, but will share a link to a google doc when I've created an outline!

Estimated first draft date:
TBD

graciegoheen commented

Got started on a draft today!

Google Doc here: Capturing Version History in dbt

krevitt commented

Modified the title here based on office hours discussion! And a few notes from that convo are here in notion.