Incremental Models

Convert full-refresh models to incremental for faster builds

Candidates

Time Saved/Run

3.2 hrs

Monthly Savings

$14,200

Approved

Incremental Conversion Candidates

Models that can benefit from incremental processing strategies

Model	Table Size	Strategy	Build Time	Monthly Savings
fct_transactions Key: transaction_id	89.2M rows	full_refreshmerge	45 min3 min	$8,500
fct_events Key: event_id	234M rows	full_refreshappend	2.5 hrs8 min	$12,000
stg_orders Key: order_id	12.4M rows	full_refreshmerge	8 min45 sec	$2,200
fct_inventory_snapshots Key: product_id	156K rows	full_refreshsnapshot	5 min30 sec	$800