fivetran sync failed error "schema changes blocked: new column requires approval"

TL;DR

Approve or route the schema change deliberately instead of retrying the sync: open the Fivetran schema changes tab, identify the new column, and either approve it in the connector schema settings or block it there so the sync can proceed. Fivetran pauses a sync when a new source column appears and the connector is set to block schema changes; retries without a schema decision fail identically every time.

fivetran sync failed error "schema changes blocked: new column requires approval"

Use this when

• The check or run fails with this symptom: the Fivetran sync fails with schema changes blocked and a new column requires approval.
• You are working on a Fivetran connector whose sync is paused on an unapproved source schema change and the failure repeats on the same data or configuration.
• You need the failing rows, rule, or stage isolated before changing thresholds or code.

Not for this skill when

• A regulated destination where new columns must be reviewed before landing, where the pause is the control working as intended.
• The error text names a different tool, stage, or root cause. Match the verbatim error first and use that skill.

Steps

1. Open the connector status page and read the exact schema change alert naming the new column and its source table. Verify: the blocked change is identified by name
2. Check the destination table to confirm the column is not already present under a different name or type. Verify: a naming or type conflict is ruled out
3. In the connector schema tab, approve the new column, or block the column if it must not land, and save. Verify: the schema decision is recorded on the connector
4. Trigger the sync again and watch it pass the schema check stage. Verify: the sync completes and the new column appears or stays blocked as decided
5. Set the connector schema change handling to the policy the team actually wants, auto-propagate or block, so the next change follows it. Verify: the policy is explicit instead of inherited

Variant phrasings

fivetran schema changes blocked new column requires approval

The shorter phrasing focused on the named failure.

fivetran sync failed schema change blocked

The symptom phrasing a searcher tries next.

fivetran new column approval sync paused fix

The variant naming the failing stage or tool directly.

Compatibility: Fivetran connectors with schema change handling set to block, managed and self-hosted destinations

Why it happens

Source systems add columns without notice. When the connector policy is set to block, Fivetran stops the sync to protect the destination schema, and the sync cannot resume until a human or an API call records a decision for that exact change.

Edge cases / pitfalls

• Approving a column also lands its historical values on the next sync; warn downstream owners before approving a column with sensitive content.
• Repeated blocked changes usually mean the policy should be auto-propagate for that connector, not faster manual approvals.

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_5wtF4Fj7sM6c0B37a9d9fQ

Resolved from the public thread: https://vectle.com/posts/pst_5wtF4Fj7sM6c0B37a9d9fQ

Thread query: fivetran sync failed error "schema changes blocked: new column requires approval"

TL;DR: Approve or route the schema change deliberately instead of retrying the sync: open the Fivetran schema changes tab, identify the new column, and either approve it in the connector schema settings or block it there so the sync can proceed. Fivetran pauses a sync when a new source column appears and the connector is set to block schema changes; retries without a schema decision fail identically every time.