Error: Ambiguous Column Name

Issue

Syncs fail with the following error:

Ambiguous column name _fivetran_id

Environment

All connectors

Resolution

To resolve this issue, check whether your source table's primary key column is named _fivetran_id. If so, rename the column, then restart the sync in Fivetran.

If a _fivetran_id column exists but isn't a primary key, contact our support team.

Cause

Fivetran reserves _fivetran_id as an internal column name. If your source table includes a column with the same name, we automatically exclude it during syncs to avoid conflicts. However, when _fivetran_id is a primary key, we can't exclude it, resulting in the above error.