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.
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.
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.
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.
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.
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.
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.
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.
Supported Data Types
Stitch now supports replication for
ARRAY data types from Postgres integrations.