BIRST - How to connect to database which is authenticated by Keypair
rayonsusan
Member Posts: 3
in Birst
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
- Driver Name:
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!
0