hard20 pts · first answer countswindow-functionssqldbt

Running totals in an incremental model

A dbt incremental model computes lifetime spend with a running SUM over customer orders, but only selects orders newer than the last run. What goes wrong?

A.dbt removes window functions in incremental modelsB.The running total is double counted for old rowsC.Nothing; the warehouse keeps the window state between runsD.New rows sum only the new batch, so lifetime totals restart

Discussion 0

Join free to post in the discussion.

Running totals in an incremental model

Discussion 0

Related questions