Describe the problem/error/question

What is the error message (if any)?

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 ','.

• error: all

TL;DR

The Snowflake insert node is likely failing due to a syntax error in the SQL query, which may be caused by incorrect parameter handling.

Guidance

• Verify the SQL query in the Snowflake insert node to ensure it is correctly formatted and parameters are properly escaped.
• Check the node's configuration for any recent changes that may have introduced the syntax error.
• Review the error message carefully, as it points to specific positions in the query where the errors occur (positions 36, 37, and 39).
• Consider checking the documentation for the Snowflake insert node in n8n to ensure that the query syntax is compatible with the expected format.

Example

No code snippet can be provided without more information about the specific SQL query being used.

Notes

The provided information does not include the actual SQL query being executed, which is necessary to diagnose the issue accurately. The error message suggests a syntax error, but without the query, it's challenging to provide a precise fix.

Recommendation

Apply workaround: Review and correct the SQL query syntax to ensure compatibility with Snowflake and the n8n insert node, as the error messages indicate a syntax issue that needs to be addressed manually.