JDBC Connection to Snowflake via MID Server using Key Pair / PAT Authentication

[AdityaA]

Hi All,

I am trying to configure a Data source using JDBC connection from ServiceNow to Snowflake using a MID Server. Earlier, we were using username/password-based authentication, but now Snowflake has moved to Passwordless authentication methods.

I would like to understand if anyone has successfully configured the JDBC connection using:

• Key Pair authentication / RSA / Private Key

• PAT (Programmatic Access Token)

If yes, could you please share how the authentication was handled on the ServiceNow/MID Server side (e.g., connection properties, driver configuration, or any specific setup required)?

Any guidance or references would be really helpful.

Thanks!

[Tanushree Maiti]

Hi @AdityaA 

Refer this and follow it :https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-configure#using-key-pair-authentication-and-...

https://community.snowflake.com/s/article/Private-key-provided-is-invalid-or-not-supported-rsa-key-p...

https://community.snowflake.com/s/question/0D50Z00009NBjgFSAT/issue-with-snowflake-jdbc-connection-u...

Also, you can refer  :https://community.servicenow.com/community?id=community_article&sys_id=4f1dc0aadb3670d0457ae6be13961...