Resources for learning about how Stitch loads and organizes data into your destination.


Data Loading by Destination

Every destination handles data differently. Learn about what your destination supports, what it doesn’t, and how Stitch will load your data as a result.

Amazon Redshift Data Loading Behavior

Learn how Stitch will load data from your integrations and handle various scenarios into a Redshift destination.

BigQuery Data Loading Behavior

Learn how Stitch will load data from your integrations and handle various scenarios into a BigQuery destination.

Panoply Data Loading Behavior

Learn how Stitch will load data from your integrations and handle various scenarios into a Panoply destination.

PostgreSQL Data Loading Behavior

Learn how Stitch will load data from your integrations and handle various scenarios into a PostgreSQL destination.


Additional Resources

These resources contain additional detail that builds upon the info covered in each destination’s data loading guide. Learn more about how Stitch structures the schemas it creates for integrations, how structural changes are handled, how to resolve record rejections, and more.

Integration Schemas

Learn how Stitch organizes the data replicated from your sources in your data warehouse.

Table Structural Changes

From time to time, Stitch will encounter data that can’t be loaded losslessly into the destination table in your data warehouse. When this happens, Stitch may have to alter the structure of the table in order to successfully load the data.

Nested JSON Data Structures & Row Count Impact

MongoDB and many SaaS integrations use nested structures, which means each attribute (or column) in a table could have its own set of attributes. Depending on the type of destination you’re using, Stitch may deconstruct these nested structures into separate tables.

Querying Append-Only Tables

In this article, we’ll cover how append-only replication works and how to account for it in your queries.

Identifying & Resolving Rejected Record Issues

From time to time, Stitch may run into problems when attempting to load data into your data warehouse. When data is deemed incompatible by the data warehouse, the record will be rejected and Stitch will log it in a rejected records log.

Tags: replication