Error workflow configuration does not work with SnowFlake node

[antonialoytorrens-ikaue]

Not sure if this behaviour should be the intended one, but this is what I'm getting:

Describe the bug On Error, if I configure the snowflake node to Continue (using error output), or Continue, I should get what the error is and/or some type of redirection.

To Reproduce Steps to reproduce the behavior:

1. Create a Snowflake node with test credentials.
2. Double click the snowflake node.
3. Set Operation to Execute Query.
4. Put a sample SQL query that for sure it will fail with an error: SELECT * FROM THIS WILL ERROR;
5. Click the options tooltip menu.
6. Set On Error to Continue (using error output) or Continue.

• If I set it to Continue (using error output), the output should redirect to Error. However, Success result is what I'm being redirected to.

• If I set it to Continue, I should get a row indicating what the error is. The error should be the output row, as an additional item, and I'm getting an empty row without results.

Execute workflow and see the results.

Expected behavior

• If I set the snowflake node to Continue (using error output), when executing the workflow the output should redirect to Error.

• If I set the snowflake node to Continue, when executing the workflow I should get an item indicating the error.

Environment (please complete the following information):

• OS: Debian 11
• n8n Version: 1.16.0
• Node.js Version: 18.17.1
• Database system: SQLite
• Operation mode: main

Additional context Use the following workflow as a testing example: Test_failing_snowflake_query.zip

[Joffcom]

Hey @antonialoytorrens-ikaue,

Thanks for the report, It looks like Snowflake node has no support at all for "continue on fail". I have created NODE-978 as the internal dev ticket to have this added in the future.

[antonialoytorrens-ikaue]

Perfect, thank you very much!