Unable to Connect live to Snowflake from Tableau Server

Issue

There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs.

Log snippet

2023-03-13 23:25:10.185 -0700 (Default,xyz@tableau.com,,ZBATQ9AKDIkYTgs6LXjiUQAAAIk) catalina-exec-1 : WARN com.tableausoftware.controller.dataserver.SessionController - Failure {"datasession":"-","datasource":"-","dserror":"-","dsexception":"class ConnectivityException","errorsrc":"DataSource","errorstatuscode":"14","failmsg":["An error occurred while communicating with the Snowflake data source 'federated.145dk3712quc0f1c2wzpt0nyxc3u' Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database. There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs. å�›æ½®æ™·æ…¬æ•«å�ç•“ç�°ç‰¯åµ´â ã€µã€´â¤´ä¤ ç™®æ±¡æ‘©æŒ æ¹¯æ•®ç‘£æ½©â�®ç‘³æ¥²æ�®.á¿�è¶ ç¾¸ "],"failtype":"UnableToConnect","request":"ZBATQ9AKDIkYTgs6LXjiUQAAAIk","site":"Default","status":"400","taberrorcode":"0xFAB9A2C5","trace":[["com.tableausoftware.controller.dataserver.DataServerException.parseException(DataServerException.java:360)","com.tableausoftware.controller.dataserver.DataServerException.fromDOM(DataServerException.java:375)","com.tableausoftwarntroller.dataserve.coer.CreateResponseParser.parseResponse(CreateResponseParser.java:89)","com.tableausoftware.controller.dataserver.SessionCreator.lambda$createSession$0(SessionCreator.java:444)"]],"user":"xyz@tableau.com"}

Environment

Tableau Server 2021.4.10
Linux
Snowflake

Resolution

Check and edit the file simba.snowflake.ini under /opt/drivers/snowflake_odbc/lib/ directory on ALL the nodes (especially Node1) and make sure encoding is set to UTF-16 -- DriverManagerEncoding=UTF-16.

[Driver]
DriverManagerEncoding=UTF-16
DriverLocale=en-US
ErrorMessagesPath=/usr/lib64/snowflake/odbc/ErrorMessages
LogNamespace=
LogPath=/tmp
ODBCInstLib=/usr/lib64/libodbcinst.so
CURLVerboseMode=false
#LogLevel=6
CABundleFile=/usr/lib64/snowflake/odbc/lib/cacert.pem

Note:

As of version 2.22.5 of the ODBC Driver, you can also specify this parameter as a configuration parameter (for example, in the simba.snowflake.ini on macOS and Linux). If this is set as both a connection parameter and a configuration parameter, the connection parameter in the DSN (or connection string) takes precedence.