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 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

2 Replies

  • 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.

  • halpert's avatar
    halpert
    New Contributor II
    4 years ago

    I was having the same error and didn’t realize I had to upload a JDBC driver. So your post was helpful.I got that error to go away.

    But when I try to validate the Snap, I get a different error (below).

    I’m using the 3.13.16 version of the JDBC driver as currently recommended in the Snowflake documentation page.

    I’m trying with the Snowflake Lookup snap. In my Snowflake account url, it has aws in the url.

    Any ideas about how to fix this error?

    Failed to validate account: java.lang.RuntimeException: Driver net.snowflake.client.jdbc.SnowflakeDriver claims to not accept jdbcUrl, jdbc:snowflake://https ://halpert3.ca-central-1.snowflakecomputing.com/:443/?ssl=on Cause: java.lang.RuntimeException: Driver net.snowflake.client.jdbc.SnowflakeDriver claims to not accept jdbcUrl, jdbc:snowflake://https ://halpert3.ca-central-1.snowflakecomputing.com/:443/?ssl=on (Reason: Driver net.snowflake.client.jdbc.SnowflakeDriver claims to not accept jdbcUrl, jdbc:snowflake://https ://halpert3.ca-central-1.snowflakecomputing.com/:443/?ssl=on; Resolution: Driver loading possibly failed, please ensure the driver is correctly configured)