
Hi fellow users,
All of a sudden, all my Tableau workbooks that use Snowflake connections return errors in Tableau Desktop. (For very small queries they keep working, though)
When I try the same queries that return the error, in SNowflake, they are successful.
Refresh extracts in Tableau Server are also not affected.
So the issue is isolated between Tableau Desktop and Snowflake.
I installed latest ODBC driver version. DId not solve my issue.
Run connectivity diagnostics in Snowflake with SnowCD, they show no internal connectivity restriction is imposed.
I am left with no more ideas on how to tackle this.
Any ideas welcome.
Error is:
Unable to complete action
Bad Connection: Tableau could not connect to the data source.
Error Code: B19090E0
[Snowflake][Snowflake] (25)
Result download worker error: Worker error: [Snowflake][Snowflake] (25)
Result download worker error: Arrow chunk download failed max retries done: Unformatted ErrorException: {Message="LocalizableDiagnostic(MessageKey=\"SFRestRequestFailed\" ComponentID=102 Params=[CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error' osCode=57 osMsg='Socket is not connected' Verify that the hostnames and portnumbers in SYSTEM$ALLOWLIST are added to your firewall's allowed list. To further troubleshoot reference the following article : https://docs.snowflake.com/en/user-guide/client-connectivity-troubleshooting/error-messages#odbc-errors])" ComponentID=102 RowNumber=UNKNOWN ColumnNumber=UNKNOWN DiagState=63}
Thank you in advance
Kind regards
Asterios Zermas
Senior Business Intelligence Analyst
Omilia Conversational Intelligence
Hi @Asterios Zermas
The error message you're encountering, "Result download worker error: Arrow chunk download failed max retries done," suggests an SSL connection issue between Tableau Desktop and Snowflake. This can occur if the Snowflake server's SSL certificate isn't recognized by your local machine. To resolve this, you can add Snowflake's SSL certificate to your machine's trusted certificate store. Alternatively, you can configure Tableau to trust the certificate by creating a Tableau Data Connection (.tdc) file with the necessary certificate information. For detailed instructions on this process, refer to the Tableau Knowledge Base article on customizing ODBC connections. https://kb.tableau.com/QuickFix?id=kA40d000000TQgG
Best regards,
Olga Ignateva