Hi all, I have a general question about Airbyte's sync mode functionality. I have a table in a Connection that I have had set to Incremental / Deduped + history because we had just wanted the most recent version of each record to replace the pre-existing one when changes occurred to pre-existing records. I had cursor field as the timestamp field in the table that identified when an existing record changed. In doing some testing, I realized that changes to the record in the destination table were not actually happening beyond the timestamp / cursor field, which was the only field updating in the destination table.
Obviously this is a problem, so I would just love to understand more about best way to handle this case. I read the documentation pages on the different sync modes, but I still need to learn more. Thanks very much!