...
JDBC protocol is used to connect to Snowflake. Snowflake JDBC driver needs to be manually copied to the operating system and accessible to the Java connector.
Download Snowflake JDBC driver. The latest version of the Snowflake JDBC driver is recommended , except (snowflake-jdbc-3.20.0.jar), for the Snowpipe Streaming storage connection - the streaming replication method currently requires JDBC driver version 3.16.1 to 3.18.0 in combination with snowflake-ingest-sdk-23.20.0.jar.
It is recommended to store the drivers in a filesystem shared between the application servers, organized in sub-directories to avoid possible conflicts (some customers connect to multiple different platforms/services). Important information is that while the path to the driver directory is defined in the storage connection (SAP GUI), the drivers themselves are loaded by the Java connector component.
...
Code Block | ||
---|---|---|
| ||
$ ls -l /sapmnt/<SID>/drivers/snowflake -rwxr-xr-x 1 <sid>adm root 69376363 Jan 15 09:45 snowflake-jdbc-3.1820.0.jar |
Sample directory with both JDBC driver and Ingest SDK for Snowpipe Streaming:
Code Block | ||
---|---|---|
| ||
$ ls -l /sapmnt/<SID>/drivers/snowflake_streaming -rw-r--r-- 1 <sid>adm sapsys 52768695 Dec 1 16:31 snowflake-ingest-sdk-23.20.0.jar -rw-r--r-- 1 <sid>adm sapsys 33471655 Jan 31 11:53 snowflake-jdbc-3.1820.0.jar |
Set its ownership and permissions appropriately to <sid>adm[:sapsys]
.
...