Error: Compilation Memory Exhausted

Question

Connectors fail with the following error:

Compilation memory exhausted.

Environment

• All connectors
• Destination: Snowflake

Resolution

Snowflake returns this error when we attempt to replicate a table with too many columns or a column with too many characters to a Snowflake destination. There are two ways to resolve this issue:

Disable unnecessary fields

To disable unnecessary fields, do the following:

1. Go to the Schema tab on your connector details page.
2. Identify tables with over 2000 fields or lengthy field names.
3. Uncheck the fields you want to exclude.
4. Click Save changes.

Disable the automatic syncing of new tables

To disable the automatic syncing of new tables and columns, do the following:

1. Go to the Schema tab on your connector details page.
2. In the top right corner, click the Schema settings (gear) icon.
3. Click Block all.
4. Click Save changes.

NOTE: If you disable the automatic syncing of new tables and columns, you must go to the Schema tab to manually enable any new tables and fields you want to replicate.