As your business evolves, your data evolves too. Stacksync lets you update your sync configuration (change table and column names, add/remove columns in sync, change datatypes).
Adding a new column in an existing sync: Explaining automatic data backfill for existing records.
The sync configuration update is a smart feature. For example, when you add a new column, all the data of that new column will backfill for the already synced records (historical data backfill), and keep syncing incrementally for any new update in real-time.
Updating a sync can be done in simple steps. Here is how:
Update your Sync configuration GIF Guide
Step 1: Pause your sync
If your data keeps syncing while you modify your schema, table or column names/types in one of your synced apps, this could impact data in your other app in sync. This is why pausing the sync ensures maximum comfort for your sensible manipulations.
Pause your Sync (Switch OFF)
Step 2: Modify your schema, table or column names/types in your external apps
Now you can do any modification you would like, feel free!
All modifications are allowed, no limits!
Step 3: Update your sync configuration
In your dashboard, open the sync details of the sync impacted by your changes.
Open Sync details
Click "Edit Sync" and follow the guided steps.
Start Editing Sync
This process is very similar to the sync creation process (reauthorize apps if necessary, map tables and fields) but with additional features that enable you to keep going from where you left off! πͺ
Step 4: Confirm your changes
Modifications to sync configuration are not reversible. Double-check your new configuration before validating!
Save your Sync edits
Step 5: Turn sync on!
Turn sync on and data starts syncing between your apps!
That's it! π Data will start syncing between your tools.