Hi everyone! I am trying to use Airbyte to replicate data from Stripe and I would like to use the incremental mode as much as possible (I am embedding Airbyte into a SaaS application I am building, so I would like to avoid full refresh as much as possible to reduce costs). Now my problem is that invoices on stripe can have different status, and the status can be updated after creation (from “draft” to “open” and then “paid”). In incremental mode, the cursor used for increments is the created date of the invoice, therefore I am missing all the status updates and this is very problematic in my case. My guess is that I have three options: 1 ) use full refresh at each sync 2 ) sync with the ‘events’ stream from stripe, which contains data about invoice updates, and then use this data to manually apply the same changes to my ‘invoices’ table 3) implement myself another solution that would listen to stripe webhooks and update my database accordingly Am I missing something ? I’d appreciate any input! Thank you

Hi. You are not missing much here since the primary key is not the only one needed to make a merge logic. either do what you have written or change the source to have more primary keys.