Stacksync Documentation
  • What is Stacksync?
  • 🚀 Start here
    • Quick start
    • Community
  • 💡Guides
    • Modify Salesforce Data in Postgres
    • 🔄Two-way sync Salesforce and Postgres
      • Create a Postgres Database with Supabase (free forever)
      • Create a Salesforce Developer instance (free forever)
      • Create a Sync between Supabase Postgres and Salesforce
    • ⚡Event Triggers
    • 🔣Add a new custom field to an existing sync
  • 🔗 Connectors
    • Salesforce
      • Authorize Salesforce
        • ⚙️Enable API Access in Salesforce
    • Postgres
      • Authorize Postgres
        • Supabase
        • Cloud SQL
        • Digital Ocean
        • Heroku
        • Amazon Lightsail
        • Amazon RDS
          • Ensuring Secure RDS Connections with SSL Certificate
        • Basedash
        • Render
        • Retool
      • Snippets
      • Required Permissions
    • BigQuery
      • Authorize BigQuery
    • HubSpot
      • Authorize HubSpot
      • Associations
      • HubDB
      • Attachments
    • MotherDuck
    • Supabase
    • Snowflake
      • Authorize Snowflake
    • Attio
      • Authorize Attio
    • Pipedrive
      • Authorize Pipedrive
    • Front
      • Authorize Front
    • Zoho
      • Authorize Zoho
    • MySQL
      • Authorize MySQL
        • Ensure Secure RDS connection with SSL Certificate
        • Access Private RDS database through SSH Tunnel
    • MariaDB
      • Authorize Mariadb
        • Ensure Secure RDS connection with SSL Certificate
        • Access Private RDS database through SSH Tunnel
    • Netsuite
      • Authorize Netsuite
    • MongoDB
    • Shopify
      • Authorize Shopify
    • Zendesk
      • Authorize Zendesk
    • 🤖Setup options
      • 🏳️IP Whitelisting
      • 🚰Manage API rate limits
      • 🌍Choose data processing region
      • SSH Tunneling
        • Access private ASW RDS instance through Jumpbox
        • Azure Jumpbox
        • Windows Server 2022 Jumpbox
        • Windows Server 2025 Jumpbox
        • GCP Jumpbox
  • 📦 API Proxy
    • Salesforce
    • HubSpot
    • Attio
    • Pipedrive
  • Features
    • Two-way sync
    • Event triggers
      • Webhook (HTTP call)
      • Database Query
    • Update Sync configuration
    • Associations support
    • Manage workspace users
    • Manage API rate limits
    • Delete Record Protection
    • Issues dashboard
    • Custom sync frequencies
    • Other features
      • Sync statistics
      • Monitoring
    • 🔐Security
      • SSO & SCIM
        • Azure Entra ID
        • OKTA
      • MFA
  • Workflows
    • Workflows Quick Start
    • Features
      • Variables and Secrets
        • Variable replacement
  • Legal
    • Terms of Service and Conditions (TC)
    • Privacy Notice
    • Service Consumption Tables
    • Global Employee and Applicant Privacy Notice
    • Acceptable Use Policy (AUP)
    • Data Processing Addendum (DPA)
    • Referral Programme Policy
    • Terms and Conditions for Stacksync Content Creator Programme
    • Stacksync Certified Partner Program Terms and Conditions
  • Security
    • Overview - Security
    • Subprocessors
    • EU Data Protection
  • Others
    • Content Creator Guidelines
Powered by GitBook
On this page
  • Step 1: Pause your sync
  • Step 2: Modify your schema, table or column names/types in your external apps
  • Step 3: Update your sync configuration
  • Step 4: Confirm your changes
  • Step 5: Turn sync on!
  1. Features

Update Sync configuration

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,...).

PreviousDatabase QueryNextAssociations support

Last updated 4 months ago

You can add/update/remove tables and fields to your existing syncs from the Stacksync dashboard. Here is a .

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.

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 impact by your changes.

Click "Edit Sync" and follow the guided steps.

Step 4: Confirm your changes

Modifications to sync configuration are not reversible. Double check your new configuration before validating!

Step 5: Turn sync on!

That's it! 🎉 Data will start syncing between your tools.

This process is very similar to the (re-authorize apps if necessary, map tables and fields) but with additional features that enable you to keep going from where you left off! 🪄

sync creation process
quick video on how to update sync config for HubSpot
Pause your Sync (Switch OFF)
Open Sync details
Start Editing Sync
Save your Sync edits
Turn sync on and data starts syncing between your apps!