hard20 pts · first answer countsdata-warehousingdbtincremental-models

Duplicates after a rerun

An incremental model uses incremental_strategy='append' and loads events where event_time > max(event_time) in the target. A failed run is retried after part of it had been written. What is the risk?

A.None; append strategies are always idempotentB.The target table is dropped and rebuiltC.Old rows are updated with new valuesD.Rows from the partial run can be loaded twice

Discussion 0

Join free to post in the discussion.

Duplicates after a rerun

Discussion 0

Related questions