Weird query results on Snowflake

If, when you use Tableau or Alteryx to query a Snowflake Database, you are getting weird $ amounts, not matching what is the database, you are experiencing a known bug in the recent versions of the Snowflake ODBC driver:

https://support.snowflake.net/s/article/Regression-in-ODBC-v2-16-4-v-2

This is a big issue affecting floating number columns. Fortunately, it has been addressed with the release of ODBC Driver version 2.16.7 in August:

https://support.snowflake.net/s/article/client-release-history

Make sure you update your ODBC driver as soon as possible!

Here are the instructions:

https://docs.snowflake.net/manuals/user-guide/odbc-download.html

This entry was posted in Alteryx, Snowflake, Tableau and tagged , . Bookmark the permalink.