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.

Redshift: Understanding the Stitch Schema Structure

Important!
The info in this doc only applies to Redshift data warehouses.

Because of the continuous and low-latency nature of Stitch, data will constantly be in flux in your data warehouse. In this article, we'll touch on how Stitch organizes your data.

Integration Schemas 

When you initially create an integration, you have the ability to define the name of the integration and the schema that will be created in your data warehouse. This schema is where the tables for the integration will be stored.

The same name can be used for the integration's display name (what shows up on the Stitch Dashboard) and the schema name, or you can choose to name them separately. For more info about how schema naming works in Stitchclick here

Here's an example of how an integration's data will be stored:

  1. You connect a MySQL database that contains two tables: orders and customers.
  2. You name this integration Customer Data. This will create a schema in your data warehouse called customer_data.
  3. After a successful sync, you'll see this integration schema in your data warehouse.
  4. In that schema, you'll see the orders and customers tables.

The tables in the integration schemas are the ones you'll interact with using an analysis integration.

Nested Data Structures

It's important to note that Redshift doesn't currently support storing nested data as-is. To compensate for this, Stitch will de-construct nested records and create subtables. This can impact your row count and your querying strategy.

For an in-depth explanation of how this works, click here.

What else should I know?

To fully understand the best way to interact with your data, we recommend you read on to learn what happens during data replication, how table structural changes are handled, and how nested data structures are handled by Stitch.

RELATED

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!