Edit on GitHub
Column ‘$4097’ Does Not Existlink
Issuelink
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"
}
Environmentlink
SQL Server connector
Resolutionlink
The upload contains more than 4096 columns. To resolve the error, reduce the number of columns.
Causelink
Many destinations have limits on the number of columns for a single table. Limit for SQL Server is 4096 columns.