Column ‘$4097’ Does Not Exist

Issue

An upload fails with the following error:

{
    "status" : "FAILURE_WITH_TASK",
    "reason" : "net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:\ncolumn '$4097' does not exist"
}

Environment

SQL Server connector

Resolution

The upload contains more than 4096 columns. To resolve the error, reduce the number of columns.

Cause

Many destinations have limits on the number of columns for a single table. Limit for SQL Server is 4096 columns.