Error: Decrease Row Size

Issue

The following errors appear:

Decrease Row Size ERROR: row is too big. Fivetran could not write data to the destination tables because their row size exceeded the destination's maximum limit.

Environment

The following Fivetran destinations:

• Azure Synapse
• MySQL
• PostgreSQL
• Snowflake
• SQL Server

Resolution

To resolve this issue, do one of the following:

1. Check whether any columns use large data types such as unlimited VARCHAR, then change them to TEXT or BLOB so that values are stored separately and don't contribute to the row size.

2. Exclude unwanted columns from your connection schema.

   i. In Fivetran, go to the relevant connection page.

   ii. Select the Schema tab.

   iii. Locate tables you want to exclude and deselect the checkbox next to the table name.

   iv. Click Save changes

3. Divide affected tables into smaller tables with fewer columns and join them using a common key.

4. Remove old or oversized values that contribute to inflated row size.

Cause

This issue occurs when a table exceeds the maximum row size supported by the destination. This may happen when you define columns with large data types, create tables with too many columns, or allow oversized values to be stored in individual rows.