Unexpected Column Addition When Schema Changes Are Blocked

Issue

My connection's schema change handling is set to Block all. However, Fivetran added a new column to a table, causing downstream failures.

Environment

Connector: PostgreSQL

Resolution

To troubleshoot this issue:

1. In Fivetran, go to your PostgreSQL connection page.
2. Select the Status tab.
3. Look for the event that shows when the column was added.
4. Check the schema change history for a recent schema refresh.
5. Determine whether a team member made a configuration change that triggered a schema refresh.
6. Check whether the column has a foreign key constraint.

Cause

Columns with foreign key constraints cannot be excluded from syncs. As a result, we may add them during a schema refresh even when the connection's schema change handling is set to Block all.