8.4
Hello!
We are trying to connect to a db view in snowflake using JDBC connector.
But snowflake is about to stop support for basic authentication. Can we still use JDBC connector with key-pair authentication?
Thanks!
yes, you can still use the JDBC connector with key-pair authentication in Snowflake. Make sure you’re using Snowflake JDBC Driver 3.13+, as it supports key-pair authentication.
Thank you @Chaithu9110 !
I have the private key in the server. And I am using following configuration in IIQ JDBC connector:
jdbc url: jdbc
//xxxx.us-east-1.snowflakecomputing.com/?user=xxxx&private_key_file=“/opt/snowflake/xxxx.p8”&role=xxxx&warehouse=xxxx&db=xxxx&schema=public
driver: net.snowflake.client.jdbc.SnowflakeDriver
The driver is snowflake-jdbc-3.22.0.jar
I am getting following error:
SQLException: JDBC driver encountered communication error. Message: No trusted certificate found Verify that the hostnames and port numbers in SYSTEM$ALLOWLIST are added to your firewall’s allowed list. To troubleshoot your connection further, you can refer to this article: Snowflake client connectivity and troubleshooting | Snowflake Documentation.
I have checked the firewall for port 80 and 443, they are open I can ping these URL from IIQ.
Do you have any idea what else could be throwing this error?
Ensure JDBC URL Uses the Correct SSL Mode
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.