Documentation and guides for configuring and managing data replication for your Stitch integrations.
Stitch Replication Process
Learn how Stitch extracts, prepares, and loads your data during the replicaiton process.
Syncing Data
Syncing Data
After you connect an integration and Stitch performs a structure sync, the next thing you’ll do is select tables and columns to sync. In this guide, we’ll walk you through how to sync/unsync objects for database and SaaS integrations.
Syncing Historical SaaS Data & Resetting SaaS Replication Keys
By default, a historical sync for most SaaS integrations will go back one year. While the Start Date setting allows you to define historical syncs, it can also reset an integration’s Replication Keys when you need to re-sync data.
Replicating Database Views
Syncing a database view is almost the same as syncing a database table. In this guide, we’ll cover the database integrations that support views and the additional steps required to sync a database view.
Syncing New & Additional Columns on Already-Syncing Tables
What happens when you add a brand-new column in a data source or you want to sync additional columns on an already-syncing table? How will your row count be impacted? In this guide, we cover how Stitch handles new columns, what you can expect for existing rows, and how to backfill data.
Supported Data Types
A full roll-up of the data types Stitch supports for replication.
Replication Settings
Replication Frequency
The Replication Frequency setting tells Stitch how often to replicate data from an integration. In this guide, we’ll explain how replication jobs are scheduled and what you should consider when defining the Replication Frequency for your integrations.
Replication Methods
Replication Methods tell Stitch how to replicate data during a replication job. In this guide, we’ll explain the methods Stitch uses, how they work for database and SaaS integrations, and how to define Replication Methods for your database integration tables.
Replication Keys for Database Integrations
Replication Keys are columns that Stitch uses to identify new and updated data for replication. These columns are one of the most important components of Stitch, as they enable Stitch to correctly capture new and updated data. In this guide, we’ll walk you through what a Replication Key is, what its requirements are, and how to choose the best column for the job.
Replication Keys for Mongo Integrations
Replication Keys for Mongo integrations have their own set of quirks and gotchas, owing to how Mongo itself is designed. In this guide, we’ll explain what to watch out for and how to choose the best field for the job.
Monitoring Replication Progress
It can be difficult to be patient when all you want is your data. In the Integration Details page for every integration, you can check out that integration’s Replication Stats. This section will give you a better idea of where your data is in the replication process.