Tableau server - Snowflake (50311) UTF-8 Error

Question

I am able to run the extract successfully in Tableau Desktop, over the Tableau server intermittently I am getting errors with the message

"java.lang.RuntimeException: [Snowflake][Support] (50311) Error converting invalid input with source encoding UTF-8 using ICU. Rejected bytes began with: ACFF."**.

Are there any settings over the Tableau server that I can enable to get rid of this error. Kindly assist.

Answer 1

Based on error code I assume you're using Snowflake ODBC driver. If that is the case, check if the result set is set to 'ARROW' (by default it is):

SHOW PARAMETERS LIKE 'ODBC_QUERY_RESULT_FORMAT';

Change result set format to 'JSON' and see if you're still getting the error (should not happen):

ALTER USER <user> SET ODBC_QUERY_RESULT_FORMAT='JSON';