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.

Data Warehouses and Management

JUMP TO

What's a data warehouse?

Quite simply, a data warehouse is a house for all your data. Whether you have just one data source or many, a data warehouse is a central repository for data accumulated from a variety of sources.

It's important to note that Stitch is not a data warehouse - data flows through the Stitch, but doesn't live there. Stitch offers Amazon Redshift, Google BigQuery, PostgreSQL, and Panoply as data warehouses to house data that flows through the Stitch.

Stitch takes the headache and guesswork out managing disparate sources of data and preparing it for analysis. Most data sources, or integrations, can be connected to Stitch with just a few simple steps.

 

How do I manage my data?

With Stitch, tracking and managing your data has never been easier. At any given time, you can view detailed status, syncing, and table information about any of your integrations.

Everyone has different ways of managing their data, so this is (mostly) a matter of preference. However, being data nerds ourselves, we do have a few recommendations:

  1. To ensure you don't go over your monthly row limit, evaluate the replication methods you're using for your tables.

    For example, if your table contains a datetime or timestamped column, using Incremental Replication instead of Full Table Replication will cut down on your usage.
  2. Setting appropriate replication methods are only part of good data management - you should also take a look at what data is being replicated in the first place. For database and some SaaS integrations, you can sync individual tables and columns, allowing you to replicate only the most relevant and useful data.
  3. If you get close to your monthly row limit, consider pausing an integration, table, or column.

Now that we've covered what a data warehouse is, lets talk about where the data comes from. In the next section, we'll cover integrations and how Stitch pulls in data from these sources.

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!