Error message "An error occurred in the external data source" appears in the TIBCO Spotfire client when running a long-running query using the Snowflake connector

Error message "An error occurred in the external data source" appears in the TIBCO Spotfire client when running a long-running query using the Snowflake connector

When running queries against Snowflake databases, using the Snowflake connector, an error similar to below sometimes appears:

Error message: An error occurred in the external data source.

ImportException at Spotfire.Dxp.Data:
An error occurred in the external data source.
External error:
ERROR [HY000] [Snowflake][Snowflake] (1) 
      Query has timed out. User specified timeout in seconds=30, Elapsed=45

This error appears when running long-running queries against a Snowflake database using the Snowflake connector, while shorter-running queries are completed successfully.  The issue occurs because of query timeouts. This can be addressed using the configurable timeouts that have been introduced for the Snowflake connector in the following versions (note: the default value has also been increased to 30 minutes):

• TIBCO Spotfire 10.3.3 LTS hotfix HF-014
• TIBCO Spotfire 10.8.0 hotfix HF-002
• TIBCO Spotfire 10.9 and higher

List of hotfixes for TIBCO Spotfire Clients (Analyst, Web Player (Consumer/Business Author) and Automation Services)

• https://community.tibco.com/wiki/list-hotfixes-tibco-spotfire-clients-analyst-web-player-consumerbusiness-author-and-automation

Keywords: snowflake, connector, An error occurred in the external data source, ERROR [HY000] [Snowflake],  Query has timed out, User specified timeout in seconds=30, Elapsed=45