Snowflake

JDBC Driver for Snowflake

DataSource

Transaction Type DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION 
net.snowflake.client.jdbc.SnowflakeBasicDataSource

Other Properties

Specify the parameters in the Other Properties field:
Parameter Description
keyPairAuthN Set to true to use key-pair authentication. For example: 
keyPairAuthN=true
warehouse Warehouse name in the Snowflake database. For example: 
warehouse=COMPUTE_WH

Required Connection Property Fields

Driver Name Server Name User Password Database Name Port Number Network Protocol
JDBC Driver for Snowflake No No No No No No

For more information about limitation, see Limitations.

Limitations

Driver Database/

Adapter IS Operating System/

Platform Affected

Limitation Description
JDBC Driver for Snowflake (snowflake-jdbc-3.9.1) , JDBC Driver for Snowflake (snowflake-jdbc-3.20.0) Snowflake 3.55.4, Snowflake 9.1.0 This driver does not support:
  1. Services: StoredProcedure, StoredProcedureWithSignature
  2. Notifications: InsertNotifications, UpdateNotifications, DeleteNotifications, StoredProcedureNotifications, StoredProcedureNotificationsWithSignature, OrderedNotifications
  3. XA_TRANSACTION connections
  4. Batch services
Note: Run the following query for select service 
ALTER SESSION SET JDBC_QUERY_RESULT_FORMAT=JSONALTER USER <DATABASE_USER> SET JDBC_QUERY_RESULT_FORMAT=JSON