How can I resolve my RETL sync that is failing with the error below and ensure it syncs as expected? – Twilio Support

Question

How can I resolve my RETL sync that is failing with the error below and ensure it syncs as expected?

"An unexpected Snowflake error occurred trying to execute your model query: 000603 (XX000): SQL execution internal error:\nProcessing aborted due to error 300016:2841755390; incident 1399896."

Product

Twilio Segment

Environment

Segment Console

Answer

This error typically occurs when a query exceeds the available memory on the warehouse node, resulting in an Out-of-Memory (OOM) failure in the execution engine.

As a mitigation, we recommend scaling up the Snowflake warehouse (for example, from Small to Medium or Large) to provide additional compute and memory resources required to complete the operation successfully.