3602459 - Failed to validate the connection to Snowflake with CamelJDBCAdapter in SAP Datasphere

• Unable to validate the connection to Snowflake in SAP Datasphere, and receive the following error.
  • 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
• The framework.trc in the DP agent contains the following error.
  •  [ERROR] JdbcMetadataBrowser | ExceptionUtil.newAdapterException [] - Failed to query schemas. org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Incoming request with IP/Token <IP_addressef> is not allowed to access Snowflake. Contact your account administrator. For more information about this error, go to https://community.snowflake.com/s/ip-xxxxxxxxxxxx-is-not-allowed-to-access.)
                                    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
                                    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
                                    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
                                    at com.sap.hana.dp.camel.JdbcMetadataBrowser.browseSchemas(JdbcMetadataBrowser.java:76)

• SAP HANA Smart Data Integration
• SAP Datasphere

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