Source
Configuring the JDBC Driver
Beginning with Snowflake version 8.24, network administrators have the option to require multi - factor authentication (MFA) for all connections to Snowflake.
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. (Note that this is not a complete list of the APIs that correspond to SQL commands.)…
Using the JDBC Driver
The Snowflake JDBC driver supports additional methods beyond the standard JDBC specification.
Performance issue when using JDBC DatabaseMetaData API methods when a schema or table contains underscore
ISSUE: JDBC metadata API call methods getColumns() and getPrimaryKeys() may scan columns from the entire database, users may experience high metadata queries execution time in a database with many tables or columns, and as a result, it…
JDBC Driver
Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed in a 64 - bit environment and requires Java LTS (Long - Term Support) versions 1.8 or higher. The driver can be used with most…
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…
How To: Use Java JDBC Client With External OAuth Token
FAQ: This article assumes that you have already configured the External OAuth and generated the OAuth token successfully.
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.
JDBC Driver Failure - net.snowflake.client.jdbc.internal.io.netty.util.internal.OutOfDirectMemoryError: failed to allocate xxx byte(s) of direct memory (used: yyy, max: zzz)
ISSUE: The following JDBC driver error occurs when attempting to fetch results: JDBC driver internal error: Fail to retrieve row count for first arrow chunk: net.snowflake.client.jdbc.internal.io.netty.util.internal.OutOfDirectMemoryError…
JDBC driver throws javax.naming.CommunicationException: DNS error (Root exception: java.net.SocketTimeoutException)
…snowflake.client.jdbc.SnowflakeConnectionV1.