Event Exceeds Size Limits Supported by the Destination
Applies To | Pipelines created with Snowflake or Amazon Redshift as the Destination |
Error Message Text(s) | Event is too large for the destination. Skip a few large columns and contact support to fix this. |
Error Summary
This error occurs when Hevo fails to load an Event into the Destination tables due to the row or column size limits imposed by the respective Destination type.
Potential Causes
-
The Event size exceeds the row size limit imposed by the Destination type.
-
A field value in the Event exceeds the maximum size supported by the Destination for the data type of that field. For example, a large nested JSON field value in the Event may exceed the size limit supported by the Destination for the JSON data type.
-
The Event contains lengthy character strings with Unicode representations, such as the null character
\u0000
.
Suggested Action(s)
-
Use Python Code-based Transformations to remove unwanted fields and reduce the size of the failed Events. You can test the Transformations on sample failed Events.
Note: You can view samples of the failed Events to identify which fields have large values that cause the Event to exceed the row or column size limits imposed by the Destination type.
-
Modify the existing field mappings from the Schema Mapper to skip the unwanted fields from being ingested in the Pipeline.
After applying any of the suggested actions, replay the failed Events to ensure that the Events are successfully loaded to the Destination. If the failed Events are not loaded, contact Hevo Support.