Improved Documentation for Snowflake

[tiafouroohi]

Component

Documentation

Is your proposal related to a problem?

No

Describe the solution you'd like

Looking for improved documentation for Snowflake:

• Current docs do not mention other SF connection properties other than JDBC URL, would be nice to clarify if the JDBC URL supports all options that the default snowflake JDBC driver supports

• Connection properties such as net.snowflake.jdbc.max_connections -nwould be nice to have in docs as it's not clear whether there is current support (when compared to the Postgres connector which allows you to configure a pool for instance)

• Not clear if SF connector uses multiple routes to service requests, if so then need clarification on whether user also needs to manage net.snowflake.jdbc.max_connections_per_route

• Requesting best practices/further learnings (query_timeout/ network_timeout, connection timeouts, tracing for JDBC etc)

Describe alternatives you've considered

N/A