Skill community advanced
Backfill Planner
Plan a backfill that doesn't melt production or corrupt the target.
Produces a backfill plan: date ranges, blast radius, resource contention, idempotency check, validation gates and rollback.
npx de-agent-platform add backfill-plannerAt a glance
| What | Plan a backfill that doesn't melt production or corrupt the target. |
|---|---|
| Where | Airflow / Orchestration · tech-airflow · tech-spark · tech-dbt |
Learning objectives
- Scope a backfill by date and by dependency
- Detect which downstream tables must also be rebuilt
- Stage a backfill gradually with validation between batches
Security scan
Last sweep 2026-10-24: 0 finding(s), 0 marked as examples.
Details
Backfill Planner
Before running anything
- Why — which dates are wrong, and what does "correct" look like?
- Blast radius — list every downstream model/table that reads the target.
- Contention — will this run beside the daily job? At what hour is the cluster idle?
- Idempotency — can each date be re-run safely?
- Rollback — snapshot the target, or write to a shadow table first.
Execution
Backfill in date batches, smallest first, validating a sample after each batch.
Registry stats
| Verification | community · Sep 19, 2026 |
|---|---|
| Completeness | 100 |
| Trust multiplier | ×1 |
| Composite | 39.5 · adequate |
| Freshness | 35 days since last source check |
| Difficulty | advanced |
| Version | 0.1.5 |
| License | Apache-2.0 |
| Security flags | 1 |
Did this solve your problem?
Backfill Planner