This can be caused by the NoExecuteInSQLPrepare parameter of the snowflake Driver.
To configure the ODBC driver to use the standard ODBC behavior, set the following parameter:
-
In Windows, in the [HKEY_LOCAL_MACHINE\SOFTWARE\Snowflake\Driver] subkey in the Windows registry, add a new String Value:
-
Value name: NoExecuteInSQLPrepare
-
Value data: true
-
-
In macOS and Linux, add the following line to your simba.snowflake.ini file:
NoExecuteInSQLPrepare=true