Backfill and Reprocessing
You add a new derived field to your user profiles: “days since last purchase.” You can compute it for new events going forward. But existing users already have purchase history. You need to compute this field for all existing users retroactively. That’s a backfill.
Backfills happen constantly in production systems. They’re more disruptive than they look.
The Basic Problem You have a dataset of 500 million user records. You need to reprocess all of them to compute the new field.