Symptom
Getting the following error message when performing the 'SELECT' statement on a Virtual Table created using a Remote Source - Snowflake:
- "CamelJdbcAdapter of type SUCCESS_MSG responding to FEDERATION_GET_NEXT" 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.
However, the JDBC URL has the database name/warehouse name/role parameters.
Read more...
Environment
SAP HANA smart data integration 2.0
Product
SAP HANA smart data integration 2.0
Keywords
Snowflake, use database, SDI, smart data integration, warehouse, role , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.