Skip to main content
Question

Snowflake JDBC KeyPair failing

  • October 18, 2024
  • 1 reply
  • 34 views

weetak
Contributor
Forum|alt.badge.img+2

i manage to set up ODBC with KeyPair but FME's JDBC connector with KeyPair is failing.  

 

 

 

Google the issue and it points to this solution : https://stackoverflow.com/questions/70303334/secretkeyfactory-not-available-error-in-snowflake-jdbc

 

 

how do i actually implement it in FME JDBC connector?

 

https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-configure#privatekey-property-in-connection-properties

Configuring the JDBC Driver | Snowflake Documentation

 

It mention about using BouncyCastle API . How do I actually enter this part of the code in FME JDBC connector?

1 reply

steveatsafe
Safer
Forum|alt.badge.img+12

@weetak On the JDBC side, I’ve made some tweaks to the “Connecting to Snowflake using Keypair Authentication” that should address the bouncy castle configuration.  

FME already ships bouncy castle libraries but they are not enabled without making use of an environment variable called JAVA_TOOL_OPTIONS.

setx JAVA_TOOL_OPTIONS -Dnet.snowflake.jdbc.enableBouncyCastle=true -m  

The above example is set in the command window and will set a system wide environment variable. For more details, see the aforementioned article.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings