BIRST - How to connect to database which is authenticated by Keypair

rayonsusan
rayonsusan Member Posts: 3

Hi,

We use Snowflake as our database with Keypair authentication. I need to connect BIRST to Snowflake but am unsure how to configure Keypair authentication within BIRST. Has anyone encountered a similar situation or can offer advice?

Here is what I have attempted so far:

  • Selected Database type as "Other" and SQL type as "Snowflake."
  • Used the following entries:
    • Driver Name: net.snowflake.client.jdbc.SnowflakeDriver
    • Connection String Format: jdbc:snowflake://myorganization-myaccount.snowflake.com/?private_key_file=/tmp/rsa_key.p8&private_key_file_pwd=dummyPassword

Unfortunately, I have not been successful. Any advice or tips would be greatly appreciated. It does not necessarily have to be specific to Snowflake; any guidance on using Keypair authentication with BIRST would be helpful.

Thanks in advance!