Full Sync Mode Support

We’re excited to announce Full Sync mode—a new Reverse ETL sync mode that gives you more control over how data flows from your warehouse to various business tools.

Similar to Upsert and Mirror modes, Full Sync mode is configured at the connection level. It ensures that the entire dataset is sent on every sync—this is ideal for teams that already handle change detection or diffs inside the warehouse.

Key details

• Full Sync mode is configured when creating a Reverse ETL connection.
• RudderStack will send the full model result set on each sync, overwriting or resending all records based on the destination’s behavior.

This mode offers maximum flexibility for advanced teams that prefer to own the sync logic in their warehouse, while still benefiting from RudderStack’s destination coverage and scheduling infrastructure.

When to use Full Sync mode

• Warehouse-managed diffs: If you’re using tools like dbt or scheduled jobs to determine which records to send, Full Sync mode lets you send that curated dataset downstream, exactly as it appears in your warehouse.
• Destinations with limited support for updates: Some tools or custom endpoints do not handle upserts or partial updates well. Full Sync mode guarantees that the complete table is refreshed every time, reducing downstream inconsistencies.

Learn more about the Full Sync mode in our docs

Screenshots

Questions? Contact us by email or on Slack