Snowflake JDBC connection help with RM Studio

Hi @CarlP,

What exact settings did You tried to establish the connection?
I suggest to use a configuration like that:
After these setting you should provide the JDBC driver Jar file under the Driver tab.
Make sure you have installed Java 1.8 or higher on your local machine, due to this is a requirement for the Snowflake JDBC driver.

I hope this will help you out!

Cheers,
Bence

Hello @CarlP

Based on Snowflake documentation the URL should look like that: jdbc:snowflake://<account_identifier>.domain.com/?<connection_params> , i suggest to modify the host and remove the snowflake:// part from that.

Cheers,
Bence

Based on the documentation the host url in this case should look like this: jea45817.us-east-1.snowflakecomputing.com , please remove the othe parts of the url.

snowflake connection success

I am getting the error No sutitable driver found for 

Hi shanila,

please make sure that the URL prefix is jdbc:snowflake://

See also this thread https://community.rapidminer.com/discussion/56737/how-to-resolve-no-suitable-driver-found-for-jdbc-snowflake-url-issue-when-connecting-to-snowflake

Greetings,
Jonas

now i am getting a different error which is a number. !390190!

That's an Snowflake error code, does your Snowflake server require SAML / SSO? 

You could try to add &authenticator=externalbrowser to the JDBC URL

Or check the ~/.RapidMiner/rapidminer-studio.log file for more details.

Unfortunately i cant find log files
or am i looking in a wrong folder?
we have a trial version
we dont use SAML/SSO
this is how i connected

snowflake://abc.snowflakecomputing.com/?authenticator=externalbrowser&user=abc

it worked after removing authenticator=externalbrowser&user=abc