OAuth with Snowflake – ODBC Driver Version Issue

Symptom When connecting to Snowflake using OAuth, you may encounter the following error:

SQLSTATE[28000] SQLDriverConnect: 390309 The user you were trying to authenticate as differs from the user tied to the access token.

This can occur if the Snowflake ODBC driver version 3.14.0 is being used for OAuth authentication. This particular driver version has been observed to cause OAuth authentication failures in some environments.

Cause The Snowflake ODBC driver version 3.14.0 has an issue where OAuth connections may not correctly handle the user associated with the access token, resulting in authentication failures.

Resolution Revert the Snowflake ODBC driver to 3.5.0 (or another earlier stable version) when using OAuth authentication with WriteBackExtreme. After downgrading the driver, retry the connection - the error should no longer occur.

Notes

  • This is related to the Snowflake ODBC driver itself, not to WriteBackExtreme.

  • Always ensure the ODBC driver version you select is compatible with your Snowflake setup and OAuth configuration.

Last updated

Was this helpful?