Warning: The Column Name Exceeds the Maximum of 63 Characters

Issue

While syncing to a PostgreSQL destination, the following warning appears:

We have skipped the following columns in the schema because the column name exceeds the maximum of 63 characters.

Environment

Destination: PostgreSQL

Resolution

To include the skipped columns, rename them at the source to be 63 characters or fewer, or use a different destination that supports longer column names.

For managed PostgreSQL destinations, you can't increase the maximum identifier length. This is only possible in self-hosted custom PostgreSQL builds.

Cause

This issue occurs when a source column name exceeds PostgreSQL's 63-byte identifier limit. PostgreSQL enforces this limit on identifier names, including column names. For more information, see PostgreSQL's Limits documentation.

Fivetran doesn't truncate or automatically rename columns that exceed this limit because doing so can cause naming collisions. Instead, Fivetran skips affected non-primary key columns. If the affected column is a primary key, the sync may fail.