SNOW-1874061: Support injecting custom socketFactory

[mayankvadariya]

What is the current behavior?

Snowflake JDBC doesn't allow injecting custom socketFactory

What is the desired behavior?

Snowflake JDBC to support injecting custom socketFactory

How would this improve snowflake-jdbc?

It helps client pass in additional socket options while making a connection

References, Other Background

Majority of the data sources supporting JDBC connectivity has builtin support for injecting custom socketFactory

• https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-configuration-options.html#jdbc20-socketfactory-option
• https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-networking.html#cj-conn-prop_socketFactory

[sfc-gh-dszmolka]

hi and thank you for raising this Issue with us. I"m wondering why would this capability be necessary, can you please expand on the use-case ? Asking because currently the driver supports a number of [user-exposed timeouts[(https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-parameters#timeout-parameters) so I'm curious what is missing.

[mayankvadariya]

hi @sfc-gh-dszmolka thanks for checking this issue. Most of the popular JDBC drivers such as mysql, postgresql already supports custom SocketFactory implementations, allowing for enhanced security and custom network configurations. Our use case is pretty much along the same lines i.e to enforce stronger security measures, such as custom SSL/TLS configurations. Our application also needs add detailed logging of socket connection along with customizing some of the other network configuration.

[sfc-gh-dszmolka]

thank you for providing us with the use-case! the team will consider this request for future planning.