Forum Discussion

mangeshj's avatar
mangeshj
New Contributor
5 years ago

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...
mbowen's avatar
mbowen
Employee
5 years ago

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.