3538952 - This session does not have a current database. Call 'USE DATABASE', or use a qualified name. - SAP HANA Smart Data Integration

When performing the 'SELECT' statement on a Virtual Table created using a Remote Source - Snowflake, the following error message is displayed.

2025-01-16 15:51:24,579 [ERROR] [9874677a-033b-4140-98da-7785ad0d294e53287] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH(441): com.sap.hana.dp.adapter.sdk.AdapterException: Camel execution failed. Reason: Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name. Context: org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[033CF82D33664DF-0000000000000000]
                                at org.apache.camel.CamelExecutionException.wrapCamelExecutionException(CamelExecutionException.java:45)
                                at org.apache.camel.support.ExchangeHelper.extractResultBody(ExchangeHelper.java:687)
                                at org.apache.camel.impl.engine.DefaultProducerTemplate.extractResultBody(DefaultProducerTemplate.java:591)
                                at org.apache.camel.impl.engine.DefaultProducerTemplate.lambda$asyncRequestBody$2(DefaultProducerTempla...
2025-01-16 15:52:00,345 [ERROR] [f0687e8e-1c26-459e-b877-aaf5acfae71555466] DefaultErrorHandler | CamelLogger.log [] - Failed delivery for (MessageId: 0F0406C85F45A0A-0000000000000000 on ExchangeId: 0F0406C85F45A0A-0000000000000000). Exhausted after delivery attempt: 1 caught: net.snowflake.client.jdbc.SnowflakeSQLException: Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name.
                                Message History (complete message history is disabled)

• SAP HANA smart data integration 2.0
• Snowflake Remote Source

Snowflake, use database, SDI, smart data integration, warehouse, role, remote source, , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem