Source
Quick reference: Snowpark Java APIs for SQL commands
This topic provides a quick reference of some of the Snowpark APIs that correspond to SQL commands.
Key pair authentication failure due to ObjectIdentifier() or SecretKeyFactory not available errors
ISSUE: Customers using the Snowflake JDBC driver using key pair authentication with encrypted private keys may see the following fatal error signature(s) thrown by the Java application during authentication: Private key provided is invalid…
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…
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.
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.
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.