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.

What's New? // August 2016

JUMP TO

August 28, 2016

Expected Shopify Data

Not sure how your Shopify data is replicating? Wonder why there are so many tables and what they contain? We updated this doc to include detailed info on how Shopify data replicates and the tables (and subtables) you can expect to see in your data warehouse.

August 25, 2016

Creating a Stitch Redshift User for an EXISTING Connection (v2 only)
Creating a Stitch Redshift User for an EXISTING Connection (v1.0/v1.1)

Want to create a Stitch Redshift user, but you've already replicated data to your data warehouse? These tutorials will walk you through the process. 

Note that creating a user for an EXISTING Redshift connection is different than creating a user for a new connection. Please be sure you're using the right doc, otherwise we may encounter issues with insufficient permissions and be unable to replicate your data.

August 24, 2016

Version 2 of the data warehouse is now available!
Check out the Stitch Data Warehouse v2 Overview & Upgrade Process doc (linked above) for all the details on what's included in the new release. New doc additions include:

Finding Your Data Warehouse Version
Not sure what data warehouse version you're on or how to find the correct docs? This doc can help.

August 19, 2016

Handling of Nested Data Structures & Row Count Impact

Is your row count higher than you expect it to be? If the integration in question uses nested data structures, it can elevate your total row count.

August 18, 2016

Connecting Mongo on Servers Using Auth Mode
Connecting Mongo on Servers Using No Auth Mode
Ready to connect your Mongo database to Stitch? The process varies a bit depending on how your server is set up: Auth versus No Auth.

Selecting & Changing Mongo Replication Keys
While Incremental Replication works the same for Mongo as it does for other integrations, the process - and gotchas - for selecting Replication Keys is a little different. 

Missing Mongo Data & Fields with Multiple Data Types
Missing Mongo data in your data warehouse? The root cause may be multiple data types in the Replication Key field.

August 15, 2016

Data Discrepancy Troubleshooting Guide
Missing some data in your data warehouse? Or maybe you've noticed some values that don't look quite right? Before you reach out to support, check out this troubleshooting guide for some common causes of data discrepancies.

Third-Party Integration Downtime
If Stitch is having trouble replicating data from one of your SaaS integrations or cloud databases, that service may be experiencing downtime. We put together a list of all our integrations' status pages so you can stay on the up-and-up.

Expected Square Data
Want to know more about our Square integration? Check out this article for detailed info on historical syncs, replication methods, and the endpoints we hit.

August 12, 2016

Expected Data Overhaul
You wanted more detail on how our SaaS integrations work, and we heard you. We spent a lot of time this week improving the Expected Data articles, which now include info on historical syncs, replication methods, and how tables and created in your data warehouse. 

So far, we've completed this for Desk.comHubSpotIntercom, and Segment. More to come soon.

August 8, 2016

Expected NetSuite Data
Want to know more about the volumes of data our NetSuite integration can replicate into your data warehouse? Use this article to get started.

Expected Zendesk Data
We updated this article to include how our Zendesk integration replicates Zendesk data and the Primary Keys for each table that will be created in your data warehouse.

August 5, 2016

Supported Data Types
Stitch now supports replication for JSONB and ARRAY data types from Postgres integrations.

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!