Full Refresh Sync
🔁 Full Refresh Syncs – How They Work in AudienceSync
🧠 Overview
Full Refresh is a sync mode in AudienceSync used when you want to completely replace existing data in the destination with new data from the source.
This method retrieves all available data, regardless of what was previously synced, ensuring the destination always holds a full, current snapshot of the source.
💡 When to Use Full Refresh
- You want to overwrite all data in the destination.
- You need a clean slate with the latest source data.
- It’s okay to lose old records that are no longer present in the source.
⚙️ How It Works
Each time a Full Refresh Sync runs:
- The system deletes existing rows in the destination table.
- It then inserts the entire dataset from the source.
📊 Example Scenario
Let’s say the destination contains a Users table:
🗂️ Before Sync
id | name | email |
1 | Alice | alice@example.com |
2 | Bob | bob@example.com |
🗂️ New Data in Source
id | name | email |
1 | Alice | alice@example.com |
3 | Carol | carol@example.com |
4 | Dave | dave@example.com |
🗂️ After Sync (Full Refresh)
id | name | email |
1 | Alice | alice@example.com |
3 | Carol | carol@example.com |
4 | Dave | dave@example.com |
📝 Notice: Bob's record was removed, and new users Carol and Dave were added.
Did this answer your question?
😞
😐
🤩
Last updated on August 6, 2021