Connectivity to add Snowflake account (on azure) from Snaplogic

Hi All,

I am trying to add Snowflake account (hosted on Azure) from Snaplogic

and i had passed all details like Snowflake account name , user id , password , warehouse name , port , but getting error in JDBC driver . . this is the jdbc driver name : net.snowflake.client.jdbc.SnowflakeDriver selected while adding snowflake account
and error is :
Failed to validate account: Could not load JDBC driver for url: {​​​​​​{​​​​​​Default JDBC driver}​​​​​​}​​​​​​ Cause: net.snowflake.client.jdbc.SnowflakeDriver (Reason: net.snowflake.client.jdbc.SnowflakeDriver; Resolution: Please verify that the driver exists at the provided location and that read permissions are granted or the JDBC Driver Class has been specified correctly in the account configuration)
we are not sure whether this jdbc driver needs to installed on Snowflake (hosted on azure)
if anyone can guide us
Regards,
Mangesh

You need to register a JDBC driver in the Snowflake account. If you click the question mark in the upper right hand corner of the account UI, it will take you to our documentation which describes how to setup the account – it’s pretty good.

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438252/Configuring+Snowflake+Accounts#SnowflakeAccount-SnowflakeS3DatabaseAccount

I recently setup a Snowflake account staging to S3, not Azure, however, the JDBC driver registration should be the same.

Here’s a link to Snowflake’s documentation regarding downloading a JDBC driver.

https://docs.snowflake.com/en/user-guide/jdbc-download.html

I surfed to this Maven repo url (link in their doc) and downloaded the v3.12.9 driver.

https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/

$ wget https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/3.12.9/snowflake-jdbc-3.12.9.jar

I uploaded this driver to SnapLogic SLDB.

Here is the configuration of my Snowflake account.

Hope this helps.