...
Java connector is a critical middle-ware component. Please follow the steps in /wiki/spaces/ReuseLib/pages/1550812246 Java Connector Setup to set it up/upgrade to a new version before you continue.
...
The Java runtime environment is narrowed per Snowflake JDBC driver requirement and must be installed in a 64-bit environment and requires Java 1.8 (or higher), link to the official page: https://docs.snowflake.com/en/user-guide/jdbc.html.
...
Storage ID
- Logical name of the storage connectionStorage type
- SNOW_STAGE (Snowflake internal stage)Java connector RFC
- TCP/IP RFC destination used for communication with Java connectorAccount name
- Name of the snowflake account without .snowflakecomputing.com
domain, in format: <account name>.<region>.<platform> (more information can be found in Snowflake account name doc).User role
- Role to be used when connecting to Snowflake (parameter is not mandatory, default role is PUBLIC)JAVA Call Repeat
- Number of times failed calls should be retriedRepeat delay (seconds)
- Delay between retried callsDriver path
- Absolute path to the directory containing the Snowflake JDBC driver.
NOTE: In previous versions of Storage Management, SAP logical file of type DIR (directory) was used. This is now automatically converted to a physical path.Connection pool size
- Number of connections that can be kept open in the pool, reducing resource-expensive establishment of JDBC connections.Username
- Snowflake user.Password
- User password.Password for JDBC Connection is Hashed
- Indicator whether the password is hashed (you can also create password hash manually by using report /DVD/XOR_GEN).
...
If Key Pair authentication is established according to https://docs.snowflake.com/en/user-guide/key-pair-auth.html#key-pair-authentication-key-pair-rotation, it can be configured with or without a passphrase as follows:
...