Sometimes, you may want to replicate data to a different location than what you initially connected to Stitch.
For example: you now want to replicate data from your integrations to a different database in your Redshift cluster, or you simply decide that Redshift isn’t the data warehouse for you.
The only prerequisite to changing destinations is that the new destination is ready to be connected to Stitch. This will minimize any downtime you may experience.
If you need a refresher on how to spin up a destination for Stitch, check out the destination setup guides.
Here’s what you need to know to ensure a smooth switch:
Some destinations may structure data differently than your current destination. For example: if you’re changing from Redshift to BigQuery, there will be some differences in how your data is stored. Detailed info about how Stitch loads data can be found in the Data Loading Guide for each destination.
Your integrations will be paused. After the switch is complete, you’ll need to manually unpause the integrations you’d like to resume.
We won’t delete or transfer any data from your current destination. To get historical data into your new destination, you’ll need to queue a full re-sync of all your integrations.
Re-syncing historical data will count towards your row usage and may take some time, depending on the volume of data and API limitations imposed by the provider.
Some webhook data may be lost during this process. Due to their continuous, real-time nature, some webhook data may be lost during the switch.
Historical data from webhook-based integrations must be either manually backfilled or replayed. Some webhook providers - such as Segment - allow customers on certain plans to ‘replay’ their historical data. This feature varies from provider to provider and may not always be available.
If you don’t have the ability to replay historical webhook data, then it must be manually backfilled after the switch is complete.
- From the Stitch Dashboard, click the Destination tab.
- At the bottom of the page, click the Change Destination button.
In the Historical Data section, select how you want data to be replicated to the new destination:
Replicate new data only: Stitch will pick up where it left off and only replicate new data to your new destination.
Replicate historical data: Stitch will clear all Replication Key values, queue a full re-replication of your integrations’ data, and replicate all historical data to your new destination. For SaaS integrations, Stitch will replicate data beginning with the Start Date currently listed in the integration’s settings.
- Click Continue. A message will display asking you to confirm the removal of the current destination’s settings.
To complete the switch, Stitch must delete your current destination configuration. Note: This will not delete data in the destination itself - it only clears this destination’s settings from Stitch.
To continue with the switch, click OK to delete the current destination settings.
- On the next page, click the icon of the destination type you want to switch to.
Follow the instructions for that destination type to complete the setup. If you need some help, refer to the destination’s setup guide:
- After you’ve successfully connected the new destination, un-pause your integrations. Your data will begin replicating according to the historical data option selected in Step 3.
If you encounter connection issues, check out the Destination Connection Errors guide for common problems and solutions.