Describe the problem/error/question
I’m using the Snowflake node with the “Execute Query” operation. In the node’s Settings, I have enabled “on error → Continue (using error output)”. However, when a SQL syntax error is triggered (for example, a malformed query), the workflow does not proceed to the Error branch as I expected.
Is this the intended behavior? If not, is there a workaround or recommended way to handle this kind of error, especially when I want to capture and route such errors explicitly?
What is the error message (if any)?
We expect to go to the “Error” branch of the Snowflake node and get the following error back:
Example of error (as seen in the execution log):
SQL compile error: Syntax error at line 1, position 15 Unexpected 'FROMXXX'
Please share your workflow
Share the output returned by the last node
In the actual output, the content values are present.
{
"headers": {
"host": "",
"user-agent": "",
"content-length": "",
"accept": "",
"accept-encoding": "",
"cache-control": "",
"cdn-loop": "",
"cf-connecting-ip": "",
"cf-ew-via": "",
"cf-ipcountry": "",
"cf-ray": "",
"cf-visitor": "",
"cf-worker": "",
"content-type": "",
"postman-token": "",
"x-forwarded-for": "",
"x-forwarded-host": "",
"x-forwarded-port": "",
"x-forwarded-proto": "",
"x-forwarded-server": "",
"x-is-trusted": "",
"x-real-ip": ""
},
"params": {},
"query": {},
"body": {
"sql": "This is where the sql query goes."
},
"webhookUrl": "",
"executionMode": ""
}
Information on your n8n setup
- n8n version:
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- n8n cloud
- Operating system:
- mac OS