---
title: "Full Data Re-Sync"
slug: "full-data-re-sync"
description: "Boost your analytics with Dataddo’s Data Re-Sync! Backfill and load all historical data effortlessly. Ensure complete datasets for better insights & reporting."
tags: ["Data backfilling", "Data flow", "Data re-sync", "Database replication"]
updated: 2025-05-16T09:09:11Z
published: 2025-05-16T09:09:11Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Full Data Re-Sync

Dataddo's **Full Data Re-Sync** feature loads **all historical data** from a connected **source** to [storage](/docs/data-storages) solutions like [BigQuery](/docs/google-bigquery), [Snowflake](/docs/snowflake), or [Databricks](/docs/databricks). This makes your data storage comprehensive, including both current and past data, improving your analytics and reporting capabilities.

Some common use cases for full data re-sync are:

- Recovering lost data
- Backfilling historical data
- Fixing past sync issues

          **DATADDO TIP**

          

See the [Full Data Re-Sync video tutorial](/docs/full-data-re-sync#video-tutorial).

## Prerequisites

Before using the **Full Data Re-Sync** feature, ensure the following conditions are met:

- **Compatible Data Destinations**: To maintain data consistency, the feature is only available for destinations that support **upsert** mode (e.g., databases, data warehouses like BigQuery, Snowflake, or Databricks).

## The Process

To start the full data re-sync, on the [**Flows**](https://app.dataddo.com/flows) page, [trigger the extraction](/docs/data-backfilling-to-storages#trigger-the-extraction) and select your date range. Dataddo then manages the sync process while handling any limitations set by the data source. For example, large requests are automatically split into smaller jobs to comply with API restrictions.

Users can oversee re-sync jobs through a dedicated dashboard, ensuring transparency and control.

          **DATADDO TIP**

          

**Full Data Re-Sync** runs separately from regular syncs to prevent disruptions to ongoing data pipelines.

Large datasets may take longer to process.

## Trigger the Extraction

1. Navigate to the [**Flows**](https://app.dataddo.com/flows) page.
2. Next to your ***flow***, click on the **Full Data Re-Sync** icon.  

![Full Data Re-Sync button](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Full%20Data%20Re-Sync.png)
3. Select your date range and **Confirm**.  

![Full Data Re-Sync Setup](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Full%20Data%20Re-sync%20-%20Config.png)

## Full Data Re-Sync Jobs Overview

After you trigger the process, check the process on the [Full Data Re-Sync Jobs overview page](https://app.dataddo.com/full-data-resync). Here, you'll find the following information information:

- Job status
- Link to the original flow (click on the ***flow*** name for redirection)
- Last re-sync update, finish date, creation date
- Re-sync log under **Quick Actions**

![Full Data Re-Sync Overview Page](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Full%20Data%20Re-sync%20Overview%20Page.png)

## Video Tutorial

[Embedded content](https://www.youtube.com/embed/iiB5Et1Q5q4)

Upsert inserts new rows and updates existing ones in the destination. By ensuring that the data in the table is updated if a matching record exists, or a new one is inserted, upsert prevents data duplication.