3591490 - Failed to import remote tables from the connection to Snowflake in SAP Datasphere

• Unable to import remote tables from the connection to Snowflake, and receive the following error.
  • getCSNDefinition: invalid remote object name: Exception occurred during execution on the exchange: Exchange[<ExchangeID>]
• The framework.trc in the DP agent contains the following error.
  • 2025-01-16 15:28:55,217 [ERROR] JdbcMetadataBrowser | ExceptionUtil.newAdapterException [] - Failed to import metadata due to exception. net.snowflake.client.jdbc.SnowflakeSQLLoggedException: JDBC driver internal error: Max retry reached for the download of #chunk0 (Total chunks: 1) retry=7, error=net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connection reset.
    2025-01-16 15:28:55,514 [TRACE] [0eb43738-9c5e-4709-9a81-f69660134db184375] RedeliveryErrorHandler | RedeliveryErrorHandler$SimpleTask.prepareExchangeAfterFailureNotHandled [] - This exchange is not handled or continued so its marked as failed: Exchange[<ExchangeId>]
    2025-01-16 15:28:55,514 [ERROR] [0eb43738-9c5e-4709-9a81-f69660134db184375] DefaultErrorHandler | CamelLogger.log [] - Failed delivery for (MessageId: AFDD426CC2406DC-0000000000000001 on <ExchangeId>: AFDD426CC2406DC-0000000000000001). Exhausted after delivery attempt: 1 caught: JDBC driver internal error: Max retry reached for the download of #chunk0 (Total chunks: 1) retry=7, error=net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connection reset.

• SAP HANA smart data integration (SDI)
• SAP Datasphere

DS, SDI, Data Provisioning Agent, CamelJDBCAdapter , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , DS-DI-RT , Remote Tables , Problem