@kapa.ai I want to update a table in destination with a sync mode that allows me to keep old records (a history of changes in the same record with same id). Can I use Incremental + Append?

Yes, Incremental | Append is exactly the sync mode that keeps a full history of changes for the same record ID. - In Incremental | Append, Airbyte only syncs new or modified data, and in the destination records are never deleted or mutated. Each new or updated record is appended to the table, so you can have multiple copies of the same record (same primary key) over time.[\[Incremental Append\]](https://docs.airbyte.com/platform/using-airbyte/core-concepts/sync-modes/incremental-append) This gives you a history-of-changes table. If instead you wanted only the latest version per ID (no history), you’d use Incremental | Append + Deduped, which keeps history in an intermediate table but exposes a final deduplicated table with one row per primary key.[\[Incremental Append + Deduped\]](https://docs.airbyte.com/platform/using-airbyte/core-concepts/sync-modes/incremental-append-deduped)