DBT - incremental strategies for late arriving data
Hey there, just wanted to leave a signpost for you. My usecases lately have been something like -
Computing a BIG table, with a lot of math in it, over a LOT of rows of data, and then joining in other data to enrich the primary set. Specifically, this is container usage data, which I'm attempting to blend with our AWS bill to arrive at something like "cost per container" per time period.
I don't want to have to rebuild this table every day because most of the data is static once it shows...