Issue

Warehouse syncs failing or partially failing with an error that says column '$4097' does not exist.

Product

Twilio Segment

Environment

Segment Console

Cause

This usually means you've reached Snowflake's limit of 4096 columns per table. 

Resolution

In order to get this fixed, you'll have to:

1. Identify what the affected table is, and why the number of columns within that table has gone over the 4096 limit.
   1. This usually happens due to columns that have been dynamically generated due to a bug in your implementation code.
2. Ensure that root cause has been addressed and stopped. e.g. bug has been fixed.
3. Reach out to Twilio Segment Support so the erroneous columns can be disabled internally.
4. Once that's done, drop these columns from your own warehouse, to allow syncs to resume.