What Happens When a New Column Is Added to the Destination Table?

Issue

What happens when additional columns are created in the destination table (that do not exist in the source)?

Environment

Destinations

Resolution

If you manually add a column to your destination's table that is not present in the source, it may cause inconsistencies and is likely to break the subsequent sync.

The solution is to delete the columns that you manually added to your destination's table and wait for the next sync to begin. For more information about schema changes, see our documentation.

Cause

This is because our sync operates in one direction: from the data source to your destination.