A destination is a centralized location into which Stitch loads data replicated from your connected and active integrations. As you do with database integrations, you have the ability to control how Stitch accesses your destination, including where data is loaded.
Stitch supports several of the most popular data warehouses on the market: Amazon Redshift, Amazon S3, Google BigQuery, Panoply, PostgreSQL, and Snowflake.
Support for multiple destinations
While all Stitch plans include support for a single destination, Stitch Enterprise can pipe data to multiple destinations for a variety of use cases:
- Cost savings and speed: Store infrequently used data in Amazon S3 for cost savings, while using a high-performing database like Amazon Redshift to store frequently used datasets.
- Development and production: Pipe data to databases specific to your various environments, ensuring availability and high performance across your entire operation.
- Dedicated warehouses: Ensure your departmental teams have access only to the data they need by replicating subsets of data to their specific destinations.
Whatever your use case, if you need data replicated to multiple destinations, Stitch has you covered.
Stitch’s access to your destination
We recommend creating a Stitch-only user that Stitch can use when connecting your destination. The permissions required to load data into a destination depend on the type of destination you want to use. In general, the Stitch user needs to be able to perform the following tasks to load data:
- Connect to and access the database,
- Create and alter schemas and tables, and
- Select data from systems tables
In the Setup section of our destination documentation, you can find detailed information and instructions about granting the required permissions to our database user.
Structure your team’s access
Stitch supports whatever way you want to structure access to your destination. As long as we have the required permissions to load data, how you grant access to your destination for the rest of your team is up to you.
Need help picking a destination?
If you don’t already have a destination in mind and you’re not sure how to make the best choice for your organization, don’t worry. Our Choosing a Destination guide can help you make the right call. In it, we walk you through each destination’s pricing structure, use cases, possible limitations, and more to ensure the destination you select is the one that best fits your needs.