We have recently updated Snowflake database access authentication from password-based to key-pai based authentication on 1st week of April, as Oracle recommended. Since then, our OAC reports getting error "Error occurs while calling remote service DatasourceService. Details: [JDSError : 78] Error Malformed URL: 344760904 - Cause: Malformed URL encountered".
While updating 'Connection String' from our BI Administration Tool (installed on RDG server) by adding new p8 file for key-based authentication as follows
jdbc:snowflake://<account>.snowflakecomputing.com/?db=<db>&schema=<schema>&warehouse=<wh>&role=<role>&authenticator=snowflake&private_key_file=<path_to_p8_file>
we are started receiving "The connection has failed" error on View Datasource from Physical side tables.
Please assist us, how to fix this issue while using Snowflake key-pair based authentication on our Model Administration Tool/RPD side