Overview

The Full Refresh mode in Multiwoven is a straightforward method used to sync data to a destination. It retrieves all available information from the source, regardless of whether it has been synced before. This mode is ideal for scenarios where you want to completely replace existing data in the destination with fresh data from the source.

In the Full Refresh mode, new syncs will replace all existing data in the destination table with the new data from the source. This ensures that the destination contains the most up-to-date information available from the source.

Example Behavior

Consider the following scenario where we have a database table named Users in the destination:

Before Sync

idnameemail
1Alicealice@example.com
2Bobbob@example.com

New Data in Source

idnameemail
1Alicealice@example.com
3Carolcarol@example.com
4Davedave@example.com

After Sync

idnameemail
1Alicealice@example.com
3Carolcarol@example.com
4Davedave@example.com

In this example, notice how the previous user “Bob” is no longer present in the destination after the sync, and new users “Carol” and “Dave” have been added.