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.

Cause

PostgreSQL enforces a 63-byte limit on identifier names, including column names. For more information, see PostgreSQL's Limits documentation.

We previously truncated column names exceeding the limit, but this led to naming collisions. To prevent issues, we now skip columns with names exceeding the limit instead of truncating them.