Get started with a free trial today
Already have an account? Sign in
Having trouble connecting your database or SaaS integration? Investigating a data discrepancy? Here you’ll find resources for some of the most common causes of connection troubles and data discrepancies related to integrations.
Known Third-Party IssuesOccasionally, some integrations used by Stitch may encounter bugs or other issues. Whenever we’ve identified a third-party issue - meaning on the integration provider’s end - we’ll post an update here.
Re-authorizing IntegrationsIf you see a message that asks you to re-authorize an integration, it means that Stitch’s permissions to that service have been revoked.
Third-Party Integration DowntimeFrom time to time, some of the applications and databases we integrate with may experience downtime. During these outages, Stitch may be unable to successfully connect to your data source and replicate your data.
Database Integration Connection ErrorsResolve errors related to connecting to a database integration.
Database Integration Extraction Error ReferenceExtraction errors for database integrations and how to resolve them.
Database Integration Table Name CollisonsIn database integrations, if the names of multiple tables canonicalize to the same name - even if they’re from different source databases or schemas - name collisions and data discrepancies can occur. This applies to any database integration available in Stitch.
Missing Mongo Data Due to Fields with Multiple Data TypesMissing some Mongo data? The root cause may be multiple data types in the Replication Key or Primary Key (_id) fields.
Mongo Fields Missing from Replication Key MenuIf you don’t see all the fields you expect to in the Replication Key field for you Mongo integration, the root cause may be insufficient permissions or a lack of field indexing.
MongoDB Disabled SessionsCursor timeouts may occur when sessions are disabled on your MongoDB server.
MySQL TINYINT(1)/boolean Columns Stored as BITIf you’ve noticed that some MySQLTINYINT(1) columns are displaying asBIT in Stitch, it’s usually due to how the MySQL driver converts this data type.
PostgreSQL Read Replicas and Slow ReplicationIf you connected a PostgreSQL read replica as a database integration and are experiencing extremely slow replication, the root cause may be the database’sstandby settings.
Unable to Load Tables Due to Source Database Access LevelMitigate issues with tables displaying in the Tables to Replicate tab by limiting the authorizing database user’s access to source tables.
Common SaaS Integration Extraction Error ReferenceExtraction errors applicable to all SaaS integrations and how to resolve them.
Google Sheets Extraction Error ReferenceExtraction errors for Google Sheets integrations and how to resolve them.
Intercom Extraction Error ReferenceExtraction errors for Intercom integrations and how to resolve them.
Missing Segment Data & Selective Integration SnippetsIf you’ve noticed some missing data from your Segment integration, the culprit might be the selective integration snippet on your website.
NetSuite Extraction Error ReferenceExtraction errors for NetSuite integrations and how to resolve them.
Pardot Extraction Error ReferenceExtraction errors for Pardot integrations and how to resolve them.
SaaS Integration Connection ErrorsIf Stitch is unable to connect to one of your SaaS integrations, the issue may be a security setting on the integration provider’s side.
Salesforce Extraction Error ReferenceExtraction errors for Salesforce integrations and how to resolve them.
Salesforce Replication & Selecting Too Many ColumnsIf a single Salesforce object has a large number of columns set to replicate, issues with replication may arise.
Stale Salesforce Data & Formula FieldsIf you’ve noticed some out-of-date Salesforce data in your data warehouse, the root cause may be a formula field.