Airbyte: When a source adds a column, propagate the schema or backfill history?

Use two invented records to separate a successful schema change from complete historical data.

Source: airbyte.com
August 24, 2026
2 min

Airbyte’s June 2026 update describes setting how source schema changes propagate at connection level. A column unused by reporting may need only a notice or no change yet. If consumers need it for old records, adding it and filling history are separate. Official docs distinguish changes detected during a sync from what happens afterward; do not assume every connector or destination backfills.

Test with two rows

Work offline with two invented rows A and B keyed by ID. The source adds color, historically TEAL for A and AMBER for B. Both values are blank at the destination after adding the field. Next only A is read again: A becomes TEAL and B stays blank. For a historical report this fails although both sides still have two rows. After a planned backfill, reconcile values by ID rather than treating every blank as no color.

Article img
Three toy snapshots: both empty, only A populated, then both A and B match.

Original reconciliation schematic, not Airbyte output. Row counts are identical in all three snapshots.

Require historical coverage when needed

Check connector, sync mode and destination support for new columns and backfill. Note column definition, rows per key, historical coverage and known nulls. Pass only with two rows, no duplicate keys and matching source values. Stop on a duplicate A or empty B and check whether only new data arrived. If history is unnecessary, document the effective coverage date. If history matters, estimate replay and downstream recomputation time; review manually before propagating if coverage cannot be checked.

Content note:This article is based on publicly available information and is intended as a reference for evaluating tools. Features, pricing, and related policies may change at any time; please refer to the latest official information.

Original source:airbyte.com