03-28-2024 07:20 AM
If we enable historical mode synchronization for a table and select only specific columns to be updated, what should we expect during synchronization if we update data in unselected columns in the source database, triggering an update operation?
Will updates in unselected columns be ignored?
Will Fivetran create rows altering the control column values without actually having an update in the selected columns?
03-28-2024 08:08 AM
Good day @marianysilva
Thank you for this question and I am investigating this functionality to determine if a Feature Request is needed. Fivetran Community: please share your insights on historical mode synchronization.
Cheers,
Toby