Issue Station
Sign In
Tools hereToolbox

n8n - ✅(Solved) Fix Snowflake Insert Nodes Placeholder Errors [1 pull requests, 1 comments, 2 participants]

Official PRs (…)
ON THIS PAGE

Recommended Tools

×6

Utilities matched from this issue’s tags and category — try them while you read without losing context.

GitHub issue graph ai analysis

Paste a GitHub issue URL. We fetch that issue, discover linked issues from bodies/comments/timeline, collect linked pull requests, and produce a structured English report.

The report is written in English Markdown for sharing and archival.

Helpful · Quick feedback

Loading…
GitHub stats
n8n-io/n8n#28952•Fetched 2026-04-24 06:13:08
View on GitHub
Comments
1
Participants
2
Timeline
5
Reactions
0
Author
DamienHarleyDamienHarley
Participants
DamienHarleyDamienHarleyn8n-assistant[bot]n8n-assistant[bot]
Timeline (top)
commented ×1cross-referenced ×1labeled ×1mentioned ×1

Error Message

Describe the problem/error/question

All Snowflake insert nodes across multiple workflows have suddenly started failing with a SQL compilation error. These workflows have been running successfully for months with no changes to logic, structure, or data. The error indicates that ? parameter placeholders are being sent to Snowflake without being bound to actual values, which causes the query to fail during compilation.

What is the error message (if any)?

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

  • error: all

Fix Action

Fixed

PR fix notes

PR #28975: fix(Snowflake Node): Add space before column list in insert query

Description (problem / solution / changelog)

Summary

Fixes the unexpected '(' SQL compilation error in Snowflake insert nodes by adding a missing space before the column list in the generated query. This resolves the recent breakages caused by updates to Snowflake's SQL parser.

Tested locally: The generated query structure INSERT INTO IDENTIFIER(?) (...) VALUES (...) now parses correctly without throwing compilation syntax errors.

Related Linear tickets, Github issues, and Community forum posts

Fixes #28952

Review / Merge checklist

  • I have seen this code, I have run this code, and I take responsibility for this code.
  • PR title and summary are descriptive. (conventions)
  • Docs updated or follow-up ticket created.
  • Tests included.
  • PR Labeled with Backport to Beta, Backport to Stable, or Backport to v1 (if the PR is an urgent fix that needs to be backported)

Changed files

  • packages/nodes-base/nodes/Snowflake/Snowflake.node.ts (modified, +1/-1)

Code Example

return items
  .filter(item => {
    const category = item.json.CATEGORY;

    return [
      "Classic Car Dealer",
      "Performance Car Dealer",
      "Regular Car Dealer",
      "Classic Motorcycle Dealer",
      "Regular Motorcycle Dealer"
    ].includes(category);
  })
  .map(item => {
    return {
      json: {
        PLACE_ID: item.json.id,
        NAME: item.json.displayName?.text || null,
        WEBSITE: item.json.websiteUri || null,
        DOMAIN: item.json.domain || null,
        FORMATTED_ADDRESS: item.json.formattedAddress || null,
        LATITUDE: item.json.location?.latitude || null,
        LONGITUDE: item.json.location?.longitude || null,
        CATEGORY: item.json.CATEGORY || null,
        JUSTIFICATION: item.json.JUSTIFICATION || null,
        REGION: item.json.region || null,
        PHONE: item.json.nationalPhoneNumber ?? null,
        SOURCE_QUERY: "classic cars",
        PROCESSED_AT: new Date().toISOString()
      }
    };
  });

---

(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.
RAW_BUFFERClick to expand / collapse
<!-- Please follow the template below. Skip the questions that are not relevant to you. -->

Describe the problem/error/question

All Snowflake insert nodes across multiple workflows have suddenly started failing with a SQL compilation error. These workflows have been running successfully for months with no changes to logic, structure, or data.

The failure began at the same time across all workflows, suggesting a system-level issue rather than a workflow-specific or data-related problem.

The error indicates that ? parameter placeholders are being sent to Snowflake without being bound to actual values, which causes the query to fail during compilation.

What is the error message (if any)?

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

Please share your workflow/screenshots/recording

return items
  .filter(item => {
    const category = item.json.CATEGORY;

    return [
      "Classic Car Dealer",
      "Performance Car Dealer",
      "Regular Car Dealer",
      "Classic Motorcycle Dealer",
      "Regular Motorcycle Dealer"
    ].includes(category);
  })
  .map(item => {
    return {
      json: {
        PLACE_ID: item.json.id,
        NAME: item.json.displayName?.text || null,
        WEBSITE: item.json.websiteUri || null,
        DOMAIN: item.json.domain || null,
        FORMATTED_ADDRESS: item.json.formattedAddress || null,
        LATITUDE: item.json.location?.latitude || null,
        LONGITUDE: item.json.location?.longitude || null,
        CATEGORY: item.json.CATEGORY || null,
        JUSTIFICATION: item.json.JUSTIFICATION || null,
        REGION: item.json.region || null,
        PHONE: item.json.nationalPhoneNumber ?? null,
        SOURCE_QUERY: "classic cars",
        PROCESSED_AT: new Date().toISOString()
      }
    };
  });
(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.

Share the output returned by the last node

<!-- If you need help with data transformations, please also share your expected output. -->

Debug info

core

  • n8nVersion: 2.17.5
  • platform: docker (cloud)
  • nodeJsVersion: 24.14.1
  • nodeEnv: production
  • database: sqlite
  • executionMode: regular
  • concurrency: 20
  • 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-23T08:20:35.028Z

extent analysis

TL;DR

The issue is likely caused by a recent change in the Snowflake node configuration or a version update, resulting in unbound parameter placeholders being sent to Snowflake, and can be fixed by reconfiguring the node to properly bind parameters.

Guidance

  • Verify the Snowflake node configuration to ensure that parameters are being properly bound to values.
  • Check the n8n version and Snowflake node version for any recent updates that may have introduced this issue.
  • Review the workflow to ensure that all parameters are being passed correctly to the Snowflake node.
  • Test the workflow with a small dataset to isolate the issue and identify any patterns.

Example

No code changes are suggested at this point, as the issue seems to be related to the node configuration or version.

Notes

The fact that the issue started occurring suddenly across all workflows suggests a system-level change, but without more information about recent updates or configuration changes, it's difficult to pinpoint the exact cause.

Recommendation

Apply workaround: Reconfigure the Snowflake node to properly bind parameters, and test the workflow with a small dataset to ensure the issue is resolved.

Vote matrix · Quick signals

Works
Did the solution work? Tap to confirm.
Easy Fix
Was it a quick fix?
Time Saver
Did it save you time?
Blocking
Was it severely blocking?
Common Issue
Are others likely hitting this too?
Flaky / Intermittent
Is it intermittent?
Verified / Reproducible
Can you reproduce it reliably?
Loading…
#api#authentication issue#prompt issue#agent setup#task chaining

Still need to ship something?

×6

Another batch ranked right after the header list — different links, same matching logic.

Back to top recommendations

TRENDING