You'll need to open a case with Tableau Support so they can look at the Tableau Online logs and help figure out why this refresh is exceeding the 2 hour timeout on Tableau Online.
I did a bit of research on this error and I discovered an instance displaying a similar behaviour with Tableau Online failing to refresh Snowflake datasource using Okta SAML with "externalbrowser" as the SAML IdP(Okta) URL after 7200 Seconds.
If this is the case, possible workaround is to replace "externalbrowser" with the URL for the SAML IdP Server and republish the data source.
For more information, please refer to the Snowflake online help article.
The possible workaround aforementioned is based on the knowledge base article below.
Please note that using "externalbrowser" is only expected to work in Tableau Desktop, and is not officially tested or supported
I hope this information help.
I am facing a different issue while publishing a Snowflake data source to Tableau Server. I am able to connect to Snowflake using SAML Idp (OneLogin) authentication and I am using externalbrowser option. I was able to see the data from Snowflake in Desktop but while publishing to Server it just hangs forever and finally fails. I see that you are able to publish it and would like to know whether you faced the same issue. BTW, I tried in 2018.2 and 2019.2 versions and both had similar issue.
In the article on using "externalbrowser" - you can see this is not expected to work on Tableau Online or Tableau Server - using MFA is not an officially supported feature:
Using "externalbrowser" is only expected to work in Tableau Desktop, and is not officially tested or supported
It looks like this issue has come up again. When trying to refresh an extract from Snowflake on Tableau Online, I'm getting the following error:
com.tableausoftware.nativeapi.exceptions.DataSourceException: [Snowflake][Snowflake] (25) Result download worker error: Worker error: [Snowflake][Snowflake] (4) REST request for URL [SERVER URL] failed: CURLerror (curl_easy_perform() failed) - code=91 msg='SSL server certificate status verification FAILED'.
We have Snowflake on Azure. A few things we tried:
- Extracts are working when done locally on Tableau Desktop
- Server credentials are working when using "Test Connection" on Tableau Online
- One small extract is completing refresh, but all others are failing
We reached out to Tableau support and they think it's a Snowflake issue. Just received an email from Snowflake support that says:
"There is an on-going network issue with Azure OCSP services which the Snowflake drivers use to check certificate revocation status as part of the authentication.
Due to this failure the drivers are unable to successfully connect.
The latest Snowflake drivers are able to circumvent this issue by using a fallback method that skips this check temporarily.
We advise to upgrade to the latest version available from https://sfc-repo.snowflakecomputing.com/odbc/index.html.
It’s possible that retrieving larger result sets (over 1 MB) fails, while smaller queries return successfully.If for some reason this continues to fail, we’d like to obtain the most recent ODBC logs for investigation (https://community.snowflake.com/s/article/How-to-generate-log-file-on-Snowflake-connectors)."
Looks like there is a driver issue occurring. Working with our SE to figure out next steps, but I think the drivers need to be updated on Tableau Online by the Tableau team.
Anyone else having this issue?