Hi. Per my understanding, Airbyte supports 4 sync modes: 1. Full refresh - Overwrite 2. Full refresh - Append 3. Incremental Sync - Append 4. Incremental Sync - Deduped History Ref: https://docs.airbyte.com/understanding-airbyte/connections but according to this link https://docs.airbyte.com/quickstart/set-up-a-connection, it says that Airbyte is doing

Full refresh

on final destination table.

At the moment, Airbyte runs a full-refresh to recreate the final tables. This can cause more costs in some destinations like Snowflake, Redshift, and Bigquery. To understand better what sync mode and frequency you should select, read this doc. There is a FAQ topic on our Discourse that more extensively explains the cost issue here.

Can someone tell me if this is still true for Incremental Sync - Deduped History too?

Hey that was true till sometime back. For Incremental sync we have moved away from that.