A new data source was successfully added to Spotfire and validated. However, when attempting to expand its contents in the Information Designer, errors appear after a few minutes.

===================================
Error message: Could not get contents of 'Prod Impala' from the server.
The data source reported a failure.
 
InformationModelException at Spotfire.Dxp.Data:
Error retrieving metadata: [Cloudera][ImpalaJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 504. (HRESULT: 80131500)

Error message: The connection to the server was closed. To continue to work and finish unsaved changes, make sure the connection is restored. Closing Information Designer will discard any unsaved changes.
 
InformationModelException at Spotfire.Dxp.Data:
The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. (HRESULT: 80131500)
===================================

All

To resolve the issue, you need to add the following setting in the existing Impala data source template.
-- <use-get-schemas>true</use-get-schemas> 

With this setting, information services use the getSchemas function to fetch schemas instead of the getTables and the getProcedures function. Using the getSchemas function improves performance, however, it shows all schemas regardless of whether these schemas have tables/ procedures. The getSchemas function is only available for JDBC versions 4.1 and later.
https://docs.tibco.com/pub/spotfire_server/14.0.6/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/xml_settings_for_data_source_templates.html

Save the template and restart the Spotfire Server(s) service.

Note: This setting can be used irrespective of data sources where metadata retrieval is taking a long time or fails to do so when expanding the data source in the Information Designer.

This article provides information about Impala data source throwing "Communication link failure. Failed to connect to server. Reason: HTTP Response code: 504" error when expanding the data source via Information Designer in Spotfire Analyst

JDBC Community link for sample data source templates: https://community.spotfire.com/articles/spotfire/spotfire-jdbc-data-access-connectivity-details/#wiki-header-22

XML settings for data source templates: https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/xml_settings_for_data_source_templates.html