Hi has anyone managed to connect RM studio 9.10 to Snowflake using JDBC? No matter what I try I can't seem to get this working. The instructions in the link below dont work and dont apply to v9.10 of RM
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.
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.
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.
RapidMiner 9.10.008 How to successfully connect using the Snowflake JDBC Driver. The 2 snapshots below show the proper way to configure RM 9.10 to Snowflake.
Altair Employee
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