Why Aren’t New Columns Syncing After I Update the Schema Change Handling Setting?

Question

Why don’t new columns sync to my destination after I update the Schema Change Handing setting from Block all to Allow columns? Do I need to enable the columns manually and run a historical re-sync? Can I enable all missing columns at once?

Environment

All connectors

Answer

Changing the Schema Change Handling setting from Block all to Allow columns doesn't automatically re-enable columns that were previously blocked. These columns appear in the Schema tab, but they won't sync to your destination until you enable them.

We don't support bulk-enabling disabled columns for a connection. To enable columns in bulk, use the REST API:

1. Retrieve the current schema configuration for each affected connection.
2. Identify columns that are disabled or excluded by the user.
3. Send PATCH requests to enable the columns you want to sync. For more information, see Modify a Connection Schema Config.

Alternatively, you can manually enable columns in the Fivetran dashboard for each table. After enabling the columns, run a historical re-sync if you want to backfill the data that was missed while the columns were disabled. To learn how, see How to Trigger Historical Re-Syncs for Fivetran Connections and Tables.