OHDSI Home | Forums | Wiki | Github

Snowflake JDBC connection issues from Atlas

Hi,

I am trying to connect an instance of Atlas to our CDM residing in snowflake. I added the following block to the settings.xml and ran the mvn package command with both webapi-postgres(for the webapi db) and webapi-snowflake.

webapi-snowflake true 3.13.22 net.snowflake snowflake-jdbc ${snowflake.driver.version}

This successfully gets the snowflake jar (snowflake-jdbc-3.13.22.jar) into the lib directory of the WebAPI but it still gives the error that no suitable driver can be found.

I tried adding the entire path to the jdbc string:
jdbc:snowflake://account.info.snowflakecomputing.com/OHDSI?user=[]&password=[]!&jar=/opt/tomcat/webapps/WebAPI/WEB-INF/lib/snowflake-jdbc-3.13.22.jar

This still gives the same error. I must be missing something so any help that can be provided would be greatly appreciated!

Best,
Alex

t