Skip to main content
Sync mode is configured per selected stream in Source. It is not a destination-wide setting.

​
Full table

Use Full table for a first validation run, small reference data, or a deliberate complete refresh. Each execution reads all rows visible to the source connection.

​
Incremental

Use Incremental when the connector supports it and the stream has a stable cursor such as updated_at, created_at, or a monotonic identifier. Enter the cursor in the stream row before clicking Save stream settings. Checkpoint state advances only after a successful run.

​
CDC (PostgreSQL)

Use CDC when you need deletes and truncates, or when a table has no reliable cursor. CDC reads changes from a logical replication slot in micro-batches. Set it up in Source → Change data capture first; until the slot is active, the CDC option is disabled and shows why. See Change data capture.

​
Connector differences

  • Airtable source currently exposes Full table only.
  • Database and supported SaaS streams can expose Incremental when a reliable cursor is available.
  • The source catalog remains authoritative for each stream’s supported modes.

​
Scheduling

Scheduling is a separate pipeline-level control in Settings. Validate a manual Run all execution before enabling an interval or UTC cron schedule.

​
Write behavior

Source sync mode and destination write behavior are separate. The current delivery mode is Upsert.