New Topic

Community Topic Question Data Sources

Chris McCarthy

Yellowfin Support Team

Assigned

Category Data Sources

Product Version 9.0

Connecting to snowflake

sepehr dabbagh shared this question ago

Answered

Hello,

We're using Yellowfin version 9.7 and trying to connect to Snowflake. I've downloaded Snowflake JDBC driver version 3.13.20 and added that into Plugin management but still snowflake is grayed out when creating a new data source. Have I missed any steps in this?

Thanks,

Sep

The same question

Replies (1)

Chris McCarthy ●

Hi Sepehr,

It seems that some of the newer Snowflake JDBC drivers are not compatible with Yellowfin. I was able to test and confirm that 3.13.9 works with Yellowfin 9.7.

/a114f2481c04d395dbe0be5bbea6c252

/cbd8e03e1961bd56bd0419e20df4987e

Are you able to use this version with your instance?

Kind regards,

Chris

Reply URL

sepehr dabbagh ●

Thanks Chris,

I downloaded 3.13.9 and Snowflake connection pops up. but there is an error when putting connection details:

Connection Failed

close_small_grey

Error Message:

javax.net.ssl.SSLPeerUnverifiedException: Certificate for <xxxxx.ap-southeast-2.snowflakecomputing.com.snowflakecomputing.com> doesn't match any of the subject alternative names: [*.prod3.us-west-2.snowflakecomputing.com, *.us-west-2.snowflakecomputing.com, *.global.snowflakecomputing.com, *.snowflakecomputing.com, *.prod3.us-west-2.aws.snowflakecomputing.com]

URL

Dean Flinter ●

When adding your account in the connection properties, you only need to add the bit before snowflakecomputing.com

So if it was 1234.us-west-2.snowflakecomputing.com then you only add 1234.us-west-2 to the account section

URL

Chris McCarthy ●

Thanks Dean!

Let me know how that goes, Sepehr.

Kind regards,

Chris

URL

sepehr dabbagh ●

It's working fine now, thanks.

URL

Chris McCarthy ●

That's great to hear! I'll mark this as answered. Enjoy your week.

URL

Dean Flinter ●

Hi Chris,

Sorry to open this one back up but thought it better than opening a new ticket

Just wondering what the latest supported Snowflake driver is?

We're facing an issue at the moment, which I may submit a ticket for but I think it may have something to do with Snowflake changing something on their side and v3 drivers are not handling it properly, leading to the issue

The latest Snowflake v4 driver has a fix but I can't get it to work. Thinking we may be using an unsupported java version (using v11)

Thanks

Dean

URL