# Keypair JDBC Authentication for Snowflake

**URL:** <https://forum.inductiveautomation.com/t/keypair-jdbc-authentication-for-snowflake/96682>\
**Category:** Ignition\
**Tags:** ignition81, database\
**Created:** [October 1, 2024, 10:30pm UTC](https://forum.inductiveautomation.com/t/keypair-jdbc-authentication-for-snowflake/96682 "2024-10-01T22:30:07Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![andrewdhunt7](https://avatars.discourse-cdn.com/v4/letter/a/d6d6ee/32.png) [@andrewdhunt7](https://forum.inductiveautomation.com/u/andrewdhunt7)\
**Post date:** [July 22, 2025, 6:57pm UTC](https://forum.inductiveautomation.com/t/keypair-jdbc-authentication-for-snowflake/96682/7 "2025-07-22T18:57:52Z")

</div>

Hi Jared, while I may only be partially able to help due to not having visibility into the Snowflake side of the configuration for the project in question, I can highlight what we did on the Ignition side. Some of the settings may not be 100% necessary

1. I followed the IA documentation's instructions for deriving a translator for Snowflake after installing the relevant files.
2. Connect URL

> jdbc:snowflake://YOURROOTSNOWFLAKEURL/?authenticator=snowflake\_jwt&db=YOURSNOWFLAKEDB&TRACING=ALL&private\_key\_file=YOURPATHTOPRIVATEKEYFILE&private\_key\_pwd=YOURPRIVATEKEYPASSWORD

Note that the Ignition service must have file access to that location.

1. Connection Props:

> CLIENT\_METADATA\_REQUEST\_USE\_CONNECTION\_CTX=TRUE;JDBC\_QUERY\_RESULT\_FORMAT=JSON;DEFAULT\_ROLE="YOURROLENAME";DEFAULT\_WAREHOUSE="YOURWAREHOUSENAME";

Let me know if that helps

---

_[View the full topic](https://forum.inductiveautomation.com/t/keypair-jdbc-authentication-for-snowflake/96682)._