Keypair JDBC Authentication for Snowflake

Ignition
,
7

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