topic Re: Snowflake Simba ODBC in Alteryx Server Discussions

Snowflake Simba ODBC

lzanotti — Thu, 07 Sep 2023 13:20:59 GMT

Hi guys,

we have recently downloaded the ODBC Snowflake from the below url

https://docs.snowflake.com/developer-guide/odbc/odbc-download

We are then using the standard Input tool and using a DSN-less connection with the gallery (which is very portable as we are a team of circa 20 members so does not require any configuration on the client machine).

I would like to know if is this one the Simba one?

Reason I am asking is that although it is quick in the client machine, I would have expected be quicker in the server but instead has the same performance. We also use a Simba ODBC for Oracle and there we can guarantee the performance are amazing when workflow run in the gallery

Do you know why might be this?

Many thanks for your help as always
Luca

Re: Snowflake Simba ODBC

fmvizcaino — Fri, 08 Sep 2023 13:17:42 GMT

Hi @lzanotti ,

No, it isn`t. You can download the Simba driver from the Alteryx licensing portal. licenses.alteryx.com

Here are some tips to improve Snowflake performance: https://community.alteryx.com/t5/Tool-Mastery/How-to-Improve-Snowflake-Speed/ta-p/1038251

One reason for the difference between performances could be the network, meaning your Oracle could be in the same network as your Alteryx server without needing to access a VPN and Snowflake being on the cloud.

Best,

Fernando Vizcaino

Re: Snowflake Simba ODBC

lzanotti — Fri, 08 Sep 2023 13:19:07 GMT

Hi @fmvizcaino many thanks for these details. I will have a go definitely soon and digest the documents you posted.

Much appreciated help !!
Thanks
Luca