Snowflake returns "Given table name already exists" when creating a schema in WritebackExtreme

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