Source
Java requirements for the JDBC Driver
The Snowflake JDBC driver requires Java LTS (Long - Term Support) versions 1.8 or higher. If the minimum required version of Java is not installed on the client machines where the JDBC driver is installed, you must install either Oracle Java…
Analyzing queries and troubleshooting with Snowpark Java
This is because Snowpark uses the Apache Arrow connector, which depends on internal Java APIs that are not exposed by default after Java 9. To work around this error, set the following parameter either as a command - line argument when…
Exception 'java.net.UnknownHostException' when connecting to scoped stage file URLs within Snowpark Java functions
CAUSE: Snowpark (Java, Scala, Python, etc.) functions execute in secure sandboxes over the Snowflake virtual warehouses and are not permitted to make any network related syscalls, including DNS resolution.
A Simple Example of Using Snowpark Java
A Simple Example of Using Snowpark Java The following example prints the count and names of tables in the current database. Replace the <placeholders> with values that you use to connect to Snowflake.
JDBC driver with -Dhttp.nonProxyHosts=* set throws java.lang.StringIndexOutOfBoundsException: begin 1, end 0, length 1
StringIndexOutOfBoundsException: begin 1, end 0, length 1 at java.
JDBC Driver Compatibility Issue With JDK 16 and Later: Exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager
CAUSE: The failure is directly caused by one of the JDBC driver's dependencies, Apache Arrow, when attempting to use reflection in order to access a private member of the java.nio.Buffer class. This was allowed by Java previously, but not…
Python and Java support for serverless tasks
Serverless tasks can invoke the following object types and functions: user - defined functions (UDFs) and stored procedures written in Python, Java, and Scala. You can use Python or Java in your tasks in a few different ways.
Creating a Session for Snowpark Java
To use Snowpark in your application, you need to create a session. For convenience in writing code, you can also import the names of packages and objects.
Can JavaScript/Java API functionalities such as connection.createStatement be used inside UDF?
User cannot create or use statements such as connection.createStatement inside UDF (not even in JavaScript UDF). This is as per the design of the Snowflake server. Example: If we try to create a Connection and Statement object inside Java…
Logging messages in Java
You can log messages from a function or procedure handler written in Java by using the SLF4J API. When you’ve set up an event table to store log entries, Snowflake stores log entries generated by your handler code in the table.