1.) Download and save the jdbc driver in under jdbc directory along with other drivers
2.) In connection dialog UI choose others ( JDBC)
3.) In Driver name "net.snowflake.client.jdbc.SnowflakeDriver"
4.) Put the connect string and test connection it should work
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
1.) download the jar (snowflake-jdbc-3.9.2.jar )file from https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/3.9.2/
2.) copy this file to ProfilerV6.2.9/lib/jdbcjar
3.) With Otherthing DB Driver put the driver name net.snowflake.client.jdbc.SnowflakeDriver
4.) Put the connect string as per snowflake URL and click on connect
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Seems like a large data so you need to increase heap space in "C:\Users\przibylla\Desktop\ProfilerV6.2.9\ProfilerV6.2.9>java -Xmx4096M -Xms4096M -classpath osdq-desktop-6.2.9-SNAPSHOT.jar;lib\rowset.jar;lib\jdbcjar;lib\hivejar;lib\hive2jar;lib;lib\saxon* org.arrah.gui.swing.Profiler"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
Can someone help me to set the configuration correctly?!
what error message you are getting on command line and in connection dialog
?
On Thu, Mar 26, 2020 at 5:23 AM Julia Przibylla juliaprz@users.sourceforge.net wrote:
--
regards,
Vivek Singh
Author of "The Reverse Journey" from Frogbooks
Connection Failed.
Driver Value Not Found - Check DB Driver field
https://docs.snowflake.com/en/user-guide/jdbc-configure.html
1.) Download and save the jdbc driver in under jdbc directory along with other drivers
2.) In connection dialog UI choose others ( JDBC)
3.) In Driver name "net.snowflake.client.jdbc.SnowflakeDriver"
4.) Put the connect string and test connection it should work
I will try it, nut do i need to specify path?
"...along with other drivers"?
Connection Failed.
Driver Class Not Found.
Look into System DSN if using jdbc:odbc bridge
Make sure Driver class is in classpath if using native
System Message:net.snowflake.client.jdbc.SnowflakeDriver
1.) download the jar (snowflake-jdbc-3.9.2.jar )file from https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/3.9.2/
2.) copy this file to ProfilerV6.2.9/lib/jdbcjar
3.) With Otherthing DB Driver put the driver name net.snowflake.client.jdbc.SnowflakeDriver
4.) Put the connect string as per snowflake URL and click on connect
if you face any issue share the screen shots
Thank you very much,
it does work, but it seems like it takes a long time to load the database ...
Hello again,
can s.o. help me to figure out the problem
BASH:
C:\Users\przibylla\Desktop\ProfilerV6.2.9\ProfilerV6.2.9>java -Xmx4096M -Xms4096M -classpath osdq-desktop-6.2.9-SNAPSHOT.jar;lib\rowset.jar;lib\jdbcjar*;lib\hivejar*;lib\hive2jar*;lib*;lib\saxon* org.arrah.gui.swing.Profiler
Mõr 27, 2020 12:20:39 PM net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
INFORMATION: I/O exception (net.snowflake.client.jdbc.internal.apache.http.NoHttpResponseException) caught when processing request to {s}->https://sfc-eu-ds1-customer-stage.s3.amazonaws.com:443: The target server failed to respond
Mõr 27, 2020 1:03:11 PM net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec execute
INFORMATION: Retrying request to {s}->https://sfc-eu-ds1-customer-stage.s3.amazonaws.com:443
loading is slow because snowflake is cloud database. You have to be co-located to have faster access. There is some URL which talks about above error
https://support.snowflake.net/s/question/0D50Z00008TSnlZSAT/jdbc-fetching-query-result-failed-with-the-target-server-failed-to-respond
https://discourse.metabase.com/t/metabase-failing-to-fetch-large-dataset/5789/2
Seems like a large data so you need to increase heap space in "C:\Users\przibylla\Desktop\ProfilerV6.2.9\ProfilerV6.2.9>java -Xmx4096M -Xms4096M -classpath osdq-desktop-6.2.9-SNAPSHOT.jar;lib\rowset.jar;lib\jdbcjar;lib\hivejar;lib\hive2jar;lib;lib\saxon* org.arrah.gui.swing.Profiler"
i realy have no expierence with increase heap space in java. where/how do I set it up?
https://stackoverflow.com/questions/1565388/increase-heap-size-in-java
make changes in runprofiler.[sh][bat]