Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Syncing Data from a SaaS Integration

Important!
The info in this doc only applies to the following integrations:

Have a suggestion? Reach out to us.

For some of our SaaS integrations, you can choose which tables should be synced to your data warehouse after a successful connection is established. 

The majority of SaaS integrations, however, will have all available data synced to your data warehouse. For detailed info on what data you can expect to see for each integration, refer to the Expected SaaS Data section.

In this article, we'll cover:

Stitch & SaaS Data Replication

Before we dive in, there are a few things you should keep in mind about how Stitch handles SaaS integrations:

  1. SaaS data can only be synced at the table level at this time. When a table is whitelisted, all columns in the table will automatically be synced to your data warehouse.
  2. The only exception to 1 is Salesforce, which can be synced down to the columnar level.
  3. Most SaaS tables use Incremental Replication, but not all. Refer to the Expected Data docs for detailed info on the replication methods used by SaaS tables.
  4. The Replication Frequency setting applies to the integration as a whole, not individual tables.

Syncing Tables

Syncing Salesforce tables.
  1. Click into the integration from the Stitch Dashboard page.
  2. In the tables list for the integration, find the table you want to sync.
  3. In the row for that table, click the icon next to the Sync Status column to sync the table.
  4. The icon will turn green and the status will change to Syncing.
  5. You can sync all tables by clicking the grey icon above the Syncing Icon column and selecting Start Syncing All Tables.

Syncing Salesforce Columns
If you want to sync individual columns from Salesforce, click into the table you want to sync. Then you can select the columns you want.

Note that column-level syncing only applies to Salesforce at this time.

Unsyncing Tables

For SaaS integrations that support table selection, you can unsync tables individually or en masse with just a few clicks.

Unsyncing Individual Tables

Unsyncing individual tables is done exactly the opposite of syncing.

  1. Click into the integration.
  2. In the row for the table you want to unsync, click the icon next to the Sync Status column. The icon will turn grey and the status will change to Not Syncing.

Unsyncing En Masse

You can unsync all tables by clicking the grey icon above the Syncing Icon column and selecting Stop Syncing All:

Unsyncing all tables.
Click for a closer look.

When will my data be in my data warehouse?

A few factors can play into how quickly you'll see the new data or changes take effect in your data warehouse:

  • The volume of data in the tables,
  • An integration's Replication Frequency setting, and
  • API quotas, which limit how many times a day a source can be queried/accessed.

All of the above can impact how long replication can take.

If your data hasn't shown up after a reasonable amount of time, reach out to our support team. We'll help you get to the bottom of it.

What's next?

If you haven't already, the next step is to set the Replication Frequency for your integration.

We recommend you also check out the articles linked below in the Related section. These resources will help you understand how your data will appear in your data warehouse, how Redshift handles schema changes, why some tables/columns have hashed names, and more.

Related:

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!