Generally, the default properties work pretty well.
Authentication
If you have a custom access key/secret access, rather than the standard username/password combination and your login path is not working correctly, then you can set:
- force_auth
- Options:
- username_password
- Assume this credential is a username/password combination
- key
- Assume this credential is a access/secret combination
Performance
However, if you want to maximize the throughput, there are a few parameters that you can tune through the jdbc client:
- client_max_connections
- maximum number of allowed open HTTP connections
- client_init_connection_timeout_millis
- time initially establishing a connection before giving up and timing out.
- client_request_timeout_millis
- time for the request to complete before giving up and timing out.
- client_request_max_retries
- number of retries for a single HTTP request before giving up
If you find these are not sufficient, please let us know.