How to aggreagte data access roles details from a view in Snowflake

IdentityIQ (IIQ) IIQ Discussion and Questions
, ,
4

hi @soswain_resmed

1. Do we need to add any additional JAR to the SailPoint library?

Yes. To use the JDBC connector with Snowflake, you need to manually add the Snowflake JDBC driver JAR to the SailPoint IIQ classpath.

  • Recommended version: snowflake-jdbc-3.13.0.jar or later (for key-pair authentication support)
  • Place the JAR in:
[IIQ_HOME]/WEB-INF/lib/
  • Restart the application server after placing the JAR.

2. How to configure key-pair authentication for Snowflake JDBC in IIQ?

Key-pair authentication is supported from Snowflake JDBC Driver 3.13+. Here’s a sample configuration:

JDBC URL Format:

jdbc: snowflake://.snowflakecomputing.com/?user=&private_key_file=<path_to_private_key>&role=&warehouse=&db=&schema=

Example:

jdbc: snowflake://abc12345.eu-central-1.snowflakecomputing.com/?user=sam_user&private_key_file=/opt/keys/snowflake_key.p8&role=SYSADMIN&warehouse=COMPUTE_WH&db=ACCESS_DB&schema=PUBLIC

Driver Class:

net.snowflake.client.jdbc.SnowflakeDriver

Snowflake JDBC in IIQ (with key-pair auth):
Snowflake JDBC connection in IIQ - SailPoint Developer Community
Includes example JDBC URL and troubleshooting tips.

Snowflake client connectivity and troubleshooting | Snowflake Documentation