Already have an account? Sign in

Multiple Destinations Overview

You can now add multiple destinations to your Stitch account! In this guide, you will learn everything you need to know on how to fully utilize this feature. Before selecting destinations, we recommend reading our guide onhow to choose a destination to ensure you’re making the decision that best suits your data warehousing needs.

Multiple Destination basics

• What are multiple destinations?

• How can I use multiple destinations?

• Who can use multiple destinations?

• How many destinations can I have?

• Can I send data from one integration to multiple destinations?

• What happens to my other destinations if I downgrade my plan?

• What happens when I delete a destination?

What are multiple destinations?

This feature allows you to load data from your integrations into more than one destination in your Stitch account.

How can I use multiple destinations?

You have multiple environments. You may want to ensure you have clean data. To do this you can house your quality assurance and production environments in the same Stitch account instead of having to maintain two unique warehouses to ingest data from each other.

You want to separate your raw data ingestion from your transformed data ingestion. You can use multiple destinations in your Stitch to load raw data from integrations into a data lake for transformation, then load your transformed data into a separate warehouse.

Who can use multiple destinations?

Clients on a Stitch Advanced or Premium plan can use this feature.

How many destinations can I have?

The default limit is 3 destinations per Stitch Advanced account, and five destinations per Stitch Premium account. To increase this limit, you must pay an add-on per additional destination. Stitch can support up to 10 destinations per account.

Can I send data from one integration to multiple destinations?

You can’t connect a single integration to multiple destinations, but you can create multiple integrations for the same data source and connect them to different destinations. The easiest way to do this is to use the connection cloning feature:

1. Create a first integration and connect it to a destination.
2. Follow the instructions in theconnection cloning documentation to clone the integration and select a different destination.

What happens to my other destinations if I downgrade my plan?

Stitch will place a hold on your account if your destination count is higher than your destination limit. When a hold is placed or lifted, you will receive an email from Stitch notifying you of the changes.

What happens when I delete a destination?

When you delete a destination, two things will happen. All post-load webhooks linked to the deleted destination will also be deleted. You will have to re-add them again if you still would like to use them in your other destinations. You will also have to choose if all data sources mapped to the deleted destination will be paused for replication or deleted. To continue replication of data, you must go back into the integration setup and re-map to where the data will be loaded.

Modifying destinations

In this section, you will learn how to add, delete, or edit a destination when you have more than one.

Adding another destination through the Stitch app

1. Login to your Stitch account.
2. ClickDestinations in the top navigation.
3. ClickAdd Destination in the top right portion of the page.
4. Select the destination you would like to setup. If you aren’t sure of which destination you should pick, followthis guide to help you make the decision that best suits your needs.

Adding another destination through the Stitch Connect API

If you want to add an aditional destination through the API, check out ourCreate a Destination with the Connect API guide.

Deleting a destination

1. Login to your Stitch account.
2. ClickDestinations in the top navigation.
3. Select the destination you would like to remove.
4. On the setup page of your destination, clickDelete Destination at the bottom of the setup.
5. Select whether you want to pause replication for the integration sources that you have mapped to the destination, or delete them.
6. Confirm that you want to remove the source by typingDELETE in the text box.
7. ClickRemove Destination.

Editing a destination

1. Login to your Stitch account.
2. ClickDestinations in the top navigation.
3. Select the destination you would like to edit.
4. Make the edits you want to make. Currently you can edit the name and description. All other available edits are specific to the data warehouse you have.
5. Save your changes.

Mapping to your destinations

In this section you will learn how to map your data sources in Stitch to your destinations.

Mapping through the Stitch app

To map a source to a destination through the Stitch app is a very simple process. Within your setup page, you will be able to select which destination you would like to map your integration to.

1. Login to your Stitch account.
2. ClickIntegrations in the top navigation.
3. Select the integration you would like to map to your destination.
4. In theTarget Destination section, select your destination. If you don’t want to map to a destination, selectNo Destination.
5. Save your changes.

Mapping through the Stitch Connect API

Mapping your data sources to via the Stitch Connect API is also a very simple process and you can do it in the Sources POST. Check out our docs onhow to create a source to learn how to do this.

Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.