MERGE mini-sim · unique_key = trip_id
Step 1 / 4

Incoming batch

trip_idpickup_datetimefare_amount

fct_trips ({{ this }})

trip_idpickup_datetimefare_amount
MATCH → update NO MATCH → insert full-refresh → rebuild
Key takeaway