Issue
An upload fails with the following error:
{ "status" : "FAILURE", "reason" : "java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.RuntimeException: com.fivetran.utils.exceptions.UncheckedSQLException: net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:\ncolumn '$4097' does not exist" }
Environment
Destination: SQL
Resolution
The upload contains more than 4096 columns. Try to reduce the number of columns.
Cause
Many destinations have limits on the number of columns for a single table.