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.

BigQuery Data Loading Behavior

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

Microsoft Azure SQL Data Warehouse Data Loading Behavior

Learn how Stitch will load data from your integrations and handle various scenarios into a Microsoft Azure 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.

Redshift Data Loading Behavior

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

Snowflake Data Loading Behavior

Learn how Stitch will load data from your integrations and handle various scenarios into a Snowflake 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.

Understanding Integration Schema Structures in Your Destination

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 destination. 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 destination. When data is deemed incompatible by the destination, the record will be rejected and Stitch will log it in a rejected records log.

System tables and columns

When data is loaded into your destination, Stitch will create some additional columns and tables. Learn about these system columns and tables and how Stitch uses them.