snowflake-jdbc | Snowflake JDBC Driver | Database library

Connection caching for browser-based SSO and token caching for multi-factor authentication (MFA) require the use of the Java Native Access (JNA) classes to save data securely to the filesystem.

As of version 3.12.18 of the JDBC Driver, the JNA classes are no longer packaged in the JDBC Driver JAR file. In the JDBC Driver pom.xml file, the dependencies on these classes are marked as optional.

If you need to use connection caching or token caching, you must add the following libraries to your classpath.

The pom.xml file for the JDBC Driver specifies the version of the JNA classes that have been tested with the JDBC Driver. We recommend using this version (or the same major version) of the JNA classes.

For more information read here

I added --add-opens java.base/java.nio=ALL-UNNAMED as VM argument for the tests and they are passing.

Please refer to this comment. Also, there is a good explanation of why this is happening. Passing the VM argument should be considered as a temporary solution.

You're calling getQueryId() rather than getQueryID(), observe ID is in capitals. The unwrap works, here is an example.

First I create a simple stored procedure:

After a day of searching and colleague's help we found the culprit being the combination of Java's latest version jdk-17_windows-x64_bin and Snowflake's one of the latest versions 3.13.9.

What worked was everything as described in original post but using Java 11.0.12 from here and snowflake-jdbc-3.10.3.jar from here.

The latest versions from Java and Snowflake's .jar together will bring you problem outlined here.

Lastly, as @Sergiu pointed out. In the SQL query I should also have explicitly specified database and scheme name.

You cannot use the output of a Snowflake stored procedure directly. If you want to get its return output, you need to run another query. This is true whether it's running from the web UI or through a driver or connector:

Could you please update Snowflake account URL and try: nw99383.eu-west-2.aws.snowflakecomputing.com/

As the exception message says:

This might have to do with you not using Generics with your java Collections

Ultimately, I was able to resolve this by:

• downloading Java straight from Oracle (rather than uninstalling and reinstalling with homebrew),
• deleting spark, downloading again (from apache, not via homebrew), and setting up environment variables as described here (mostly... I use a virtual environment so I didn't hardcode PYSPARK_PYTHON to system python3)
• uninstalling pyspark and reinstalling
• quitting pycharm and reopening (this refreshed all my environment variables that were set in .zshrc, like JAVA_HOME)

There's almost certainly an easier way, but this worked.