Source
Analyzing queries and troubleshooting with Snowpark Java
To inspect the evaluation plan of a DataFrame, call the explain method of the DataFrame. This prints the SQL statements used to evaluate the DataFrame. If there is only one SQL statement, the method also prints the logical plan for the…
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.
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…
Setting Up IntelliJ IDEA CE for Snowpark Java
Choose File » New » Project. From the Project SDK menu, select 11 (for Java version 11). Note that you don’t need to select an archetype. You can just leave the Create from archetype box unchecked.
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.
ERROR: "Exception in thread "main" java.io.IOException: ObjectIdentifier() -- data isn't an object ID (tag = 48)" while using Public/Private Key Pair Authentication with Snowflake JDBC Driver.
ERROR: "Exception in thread "main" java.io.IOException: ObjectIdentifier() - - data isn't an object ID (tag = 48)" while using Public/Private Key Pair Authentication with Snowflake JDBC Driver.
JDBC driver throws javax.naming.CommunicationException: DNS error (Root exception: java.net.SocketTimeoutException)
ISSUE: The following exception occurs on macOS (aarch64) when using the JDBC driver’s diagnostic feature (i.e., ENABLE_DIAGNOSTICS=TRUE)…
JDBC driver with -Dhttp.nonProxyHosts=* set throws java.lang.StringIndexOutOfBoundsException: begin 1, end 0, length 1
ISSUE: When using the JDBC driver's diagnostics feature (i.e., ENABLE_DIAGNOSTICS=TRUE)1, if the -Dhttp.nonProxyHosts=* JVM argument is set, the following exception can occur on some Java versions: java.lang.RuntimeException: java.lang.St…
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…