ETL Incremental Patterns Patterns for incremental data loading and backfill operations. Backfill Strategy Incremental Load Patterns Timestamp-Based Incremental Change Data Capture (CDC) Full Refresh with Swap Pipeline Orchestration Load Strategy Decision Matrix | Scenario | Pattern | When to Use | |----------|---------|-------------| | Small tables (<100K rows) | Full refresh | Daily/hourly loads | | Large tables with timestamps | Timestamp incremental | Continuous sync | | Source supports CDC | CDC events | Real-time updates | | One-time historical load | Parallel backfill | Initial migratio…