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!