SAP Knowledge Base Article - Public

3330274 - SAP Datasphere to Snowflake Database using generic JDBC Connection Fails

Symptom

SAP Datasphere to Snowflake Database using generic JDBC Connection Fails :

The Connection fails with Connection "Connection_name" couldn’t be established.
- Data flows are not supported.
- Replication flows are not supported.
- Remote tables can't be used because of errors in the connection.

Remote Tables: internal error: Cannot get remote source objects: Could not get tables, Code: 403, SQL State: HY000

Environment

SAP Datasphere

Cause

wrong configuration in the JDBC URL specified to define the connection. 

Resolution

The JDBC URL should be defined as follow :

jdbc:snowflake://<your_account_and_region>.snowflakecomputing.com?db=SNOWFLAKE_SAMPLE_DATA&warehouse=sample_wh_xs

See Also

How to add Snowflake as a source for SAP Datasphere or SAP HANA Cloud | SAP Blogs

Keywords

Datasphere, Snowflake, JDBC,  HY000, tables , KBA , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions