ELT pipelines
Extract from the source, load it into your warehouse as-is, and transform it there—where the compute already lives and the raw record is still available to re-derive from.
- Incremental sync — each run picks up where the last one stopped, using the replication key you choose, instead of re-reading the whole table.
- Backfill when you need it — reset a pipeline's sync state to re-read the table from scratch.
- Raw stays raw — the loaded table is the source of truth, so a modelling mistake costs you a re-run of a transformation, not a re-sync.