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)→ExecuteActual (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.
✅ Steps:
Open your ODBC configuration file
Set the following parameter:
Save and restart your connection/service
This forces the driver to prepare statements properly before execution, as expected by WriteBackExtreme.
🔗 References:
Last updated