Users may report that the queries fail with the following error message in the Client debug logs (Spotfire.Dxp.SupportDiagnostics.log) :

An error occurred when executing a query in the external data source.
Exemal error:
ERROR [HY000] [Simba][Hardy] (35) Error from server: error code: '0' error message: "[Simba][Hardy] (134) File ed2069bd-d087-4199-8c3a-2ce0f37f4843: A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded. Error Detail: File ed2069bd-d087-4199-8c3a-2ce0f37f4843: The result file URL had expired on 1778162251291 

This error originates externally from the Databricks/Spark database engine.

When retrieving large result sets, the driver requests direct-download pre-signed URLs from cloud storage (AWS S3, Azure Blob, or Google Cloud Storage). If network latency, strict firewall policies, or prolonged query processing causes the pre-signed URL to expire before the client finishes downloading the result files, the process fails with a retriable cloud store error.

All

To resolve this issue, disable direct cloud storage result downloads by setting EnableQueryResultDownload=0. This forces the Simba driver to stream query results directly through the standard driver channel.

Choose any one of the following methods to apply the configuration:

Option 1: Add a Custom Property to the Spotfire Data Connection (Recommended)

1. Open Spotfire Analyst and create a new data connection or edit an existing one (e.g., Connect to Databricks).
2. On the connection data source window, click More properties.
3. Click Add property.
4. Select or enter the property name: EnableQueryResultDownload.
5. Set the property value to 0.
6. Save and re-test the connection.
For detailed guidance, refer to the official Spotfire documentation on Properties in connection data sources.

Option 2: Configure via System DSN (ODBC Data Source Administrator)

If your connection uses a System DSN rather than the native connector UI:
1. Open ODBC Data Source Administrator (64-bit) on the machine running Spotfire Analyst or the Spotfire Node Manager.
2. Navigate to the System DSN tab, select your DSN, and click Configure.
3. Click Advanced Options... > Server-Side Properties (or Advanced Properties, depending on driver version).
4. Add a key-value pair:
Key: EnableQueryResultDownload
Value: 0
5. Click OK and apply the changes.
6. For Spotfire Analyst: Restart the Analyst client application.
7. For Web Player / Automation Services: Restart the Spotfire Node Manager Service on the server hosting the Web Player instance to reload driver registry settings

Option 3: Configure via Windows Registry Editor

To enforce this setting globally across all connections using the Simba driver on a specific machine:
1. Open regedit.exe on the local computer (or Node Manager server).
2. Navigate to the Simba Spark driver registry path:
HKEY_LOCAL_MACHINE\SOFTWARE\Simba\Simba Spark ODBC Driver\Driver
(Or for DSN-specific configurations: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<Your_DSN_Name>)
3. Right-click on the key > New > String Value.
4. Name the value: EnableQueryResultDownload
5. Double-click the entry and set the Value data to 0.
6. Restart Services.
7. For Spotfire Analyst: Restart the Analyst client application.
8. For Web Player / Automation Services: Restart the Spotfire Node Manager Service on the server hosting the Web Player instance to reload driver registry settings

When executing queries against external data sources using the Simba driver in Spotfire Analytics, users may encounter an error indicating a failure to download result files from the cloud store. 

Doc: Properties in connection data sources - 

• https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire_client/client/topics/en-US/connectors_properties_in_connections.html

Doc: Connector for Apache Spark SQL — Features and settings -

• https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire_client/client/topics/en-US/connector_apache_spark.html

External doc:

• https://knowledge.alteryx.com/index/s/article/Error-SQLExtendedFetch-SimbaHardy-Error-from-server-error-code-0-error-message-SimbaHardy-134-A-retriable-error-occurred-while-attempting-to-download-a-result-file-from-the-cloud-store-but-the-retry-limit-had-been-exceeded