n8n - 💡(How to fix) Fix Snowflake insert node stopped working correctly [2 comments, 3 participants]

Describe the problem/error/question

The "Snowflake Insert" node stopped working after the last version update. The node worked before. There were no changes to the underlying data or to the flow itself. Seems like the initial table name and columns are missing from the API call. The current log on Snowflake shows this statement that failed: INSERT INTO IDENTIFIER(?)(IDENTIFIER(?),IDENTIFIER(?),IDENTIFIER(?),IDENTIFIER(?),IDENTIFIER(?),IDENTIFIER(?),IDENTIFIER(?)) VALUES (?,?,?,?,?,?,?)

Whereas previous runs shows these statements: INSERT INTO zoom.production.changelog_facts_tracking(TABLE_NAME,COLUMN_NAME,JOIN_KEY,INCLUDE_IN_CHANGELOG,FILTER_CLAUSE,DATA_TYPE,UPDATE_TS_COLUMN) VALUES (?,?,?,?,?,?,?)

There is no issue of empty data or missing data. We've created similar test flows to check if this is a data issue, and didn't find any issue with the data itself.

What is the error message (if any)?

{ "errorMessage": "SQL compilation error:\nsyntax error line 1 at position 36 unexpected '('.\nsyntax error line 1 at position 37 unexpected '?'.\nsyntax error line 1 at position 39 unexpected ','.", "errorDetails": {}, "n8nDetails": { "n8nVersion": "2.17.5 (Cloud)", "binaryDataMode": "filesystem", "stackTrace": [ "OperationFailedError: SQL compilation error:", "syntax error line 1 at position 36 unexpected '('.", "syntax error line 1 at position 37 unexpected '?'.", "syntax error line 1 at position 39 unexpected ','.", " at createError (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/snowflake-[email protected]_asn1.js@[email protected]/node_modules/snowflake-sdk/lib/errors.js:557:17)", " at Object.exports.createOperationFailedError (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/snowflake-[email protected]_asn1.js@[email protected]/node_modules/snowflake-sdk/lib/errors.js:360:10)", " at Object.callback (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/snowflake-[email protected]_asn1.js@[email protected]/node_modules/snowflake-sdk/lib/services/sf.js:673:28)", " at /usr/local/lib/node_modules/n8n/node_modules/.pnpm/snowflake-[email protected]_asn1.js@[email protected]/node_modules/snowflake-sdk/lib/http/base.js:48:24", " at processTicksAndRejections (node:internal/process/task_queues:104:5)" ] } }

Please share your workflow/screenshots/recording

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
⚠️ WARNING ⚠️ If you have sensitive data in your workflow (like API keys), please remove it before sharing.

{ "nodes": [ { "parameters": { "table": "ZOOM.PRODUCTION.CHANGELOG_FACTS_TRACKING", "columns": "=TABLE_NAME,COLUMN_NAME,JOIN_KEY,INCLUDE_IN_CHANGELOG,FILTER_CLAUSE,DATA_TYPE,UPDATE_TS_COLUMN" }, "type": "n8n-nodes-base.snowflake", "typeVersion": 1, "position": [ 752, 0 ], "id": "845e4d18-0719-4db9-9602-aa0ad128fe7a", "name": "Snowflake", "credentials": { "snowflake": { "id": "gxT9Tw3Ec16eF9AL", "name": "n8n user" } } } ], "connections": { "Snowflake": { "main": [ [] ] } }, "pinData": {}, "meta": { "templateCredsSetupCompleted": true, "instanceId": "74098f9290bae6008e5b4c14e779486237d1132a3ed8565e8ee5dcde6c64b2ba" } }

Share the output returned by the last node

Debug info

core

• n8nVersion: 2.17.5
• platform: docker (cloud)
• nodeJsVersion: 24.14.1
• nodeEnv: production
• database: sqlite
• executionMode: regular
• concurrency: 50
• license: enterprise (sandbox)

storage

• success: all
• error: all
• progress: false
• manual: true
• binaryMode: filesystem

pruning

• enabled: true
• maxAge: 720 hours
• maxCount: 25000 executions

client

• userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/147.0.0.0 safari/537.36
• isTouchDevice: false

Generated at: 2026-04-23T06:30:02.421Z