search

Snowflake schema creation fails with "undefined" error.

Cause: The error occurs due to a behavior in Snowflake's default PDO/ODBC driver. Unlike other databases, the Snowflake ODBC driver executes SQL statements immediately — even during the prepare phase — instead of using the standard flow:

Expected: Prepare (sanitize input) → Execute Actual (Snowflake): Prepare → Immediately executes DDL

This behavior conflicts with how WriteBackExtreme safely prepares queries for execution, resulting in schema creation failure.

Symptoms:

  • Creating a new schema in Snowflake fails

  • Error message shown: “undefined”

  • WriteBackExtreme cannot proceed with schema operations

Resolution: To resolve this, you must configure the ODBC driver to restore the correct SQL prepare behavior.

hashtag
✅ Steps:

  1. Open your ODBC configuration file

  2. Set the following parameter:

    NoExecuteInSQLPrepare=true

  3. Save and restart your connection/service

This forces the driver to prepare statements properly before execution, as expected by WriteBackExtreme.

hashtag
🔗 References:

PreviousUnable to access WriteBackExtreme Management Console.NextKnown Limitations & Workarounds

Last updated

Was this helpful?