Can incremental perform merge?

Quick question about Incremental I Append Sync mode. In this mode, does airbyte just pull changes since last ingestion using cursor field and perform merge operation on the destination (databricks delta)? I see it only doing append is it possible to upsert instead? I am using Open source version of Airbyte

Hey if you mean to remove duplicate records then we have an option called incremental dedup which you can use

I mean something like upsert or merge into when writing to delta in databaricks.

we don’t have a upsert thing but we append and dedup. Feel free to create a ticket as improvement over github so that team can comment over it