Connector Improvement: More Full Table Syncs
Not planned
The fountain connector only does incremental syncs for the applicant schema and applicant_data table which populates very frequently. We'd like for this to be full syncs in order for the data to always be updated with the most up to date information for the applicants.
-
Official comment
Hi Natalie,
The Fivetran sync process begins with a historical (initial) sync for all selected tables, after which the connector moves to incremental sync mode—pulling only new or modified data using cursors to track changes. For the fountain connector, the applicant schema and applicant_data table are configured for incremental syncs due to the high frequency of updates and the ability to track changes efficiently.
If you need a full refresh of applicant data to address data integrity or ensure the most current information, you can trigger a re-sync from your Fivetran dashboard. A re-sync reimports all historical data in the relevant tables. Note that ongoing full table syncs may impact source and destination performance, so we default to incremental mode for efficiency. However, this shouldn't be required to fully replicates all the changes in the sources. If you are seeing missing updates please open a support ticket.
For more information on sync types, see our documentation: Sync Overview.
Thanks,
Shiva
Please sign in to leave a comment.
Comments
1 comment