Question
Tokio Marine Holdings Inc.
GB
Last activity: 1 Dec 2024 18:32 EST
PEGA Cloud - SNOWFLAKE INTEGRATION using Db Instance and JDBC url authentication
Hi
From Pega Cloud, I need to connect to an external database in Snowflake
I can successfully test the connection using the basic JDBC URL
jdbc:snowflake://<instance.region>.snowflakecomputing.com/?db=<mySnowflakedbName>
I have the requirement to not just secure the above connect but also authenticate the same, has anyone used any additional parameters and can work with the same
Snowflake provides additional param to secure and authenticate the JDBC connection using parameters like
privateKey; authenticator; privatekey; token
the param are copied from below Snowflake link
https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-configure
https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-parameters