SNOW-521487: SnowflakeConnectionV1.close() is a bottleneck

[Nandakumar-M]

SnowflakeConnectionV1.close() is sending out telemetry data. This is happening via the TelemetryThreadPool which has max thread size as 10.

This becomes a bottleneck when large number of threads are concurrently opening and closing snowflake connections.

#664

[sfc-gh-hchaturvedi]

Hey @Nandakumar-M, in order to better support this case, we'd need to look at more detailed logs from the driver. In order to ensure that the logs remain in a controlled environment I'd request you to create a support ticket. However if you can ensure that there isn't any sensitive information in the logs, please share the entire logs here so that we can triage this issue better. From the driver's perspective there are two types of telemetry - out of band and in band. We'd need to understand which telemetry is this because OOB telemetry should be sent only in case of an internal error.

[sfc-gh-igarish]

To clean up and re-prioritize more pressing bugs and feature requests we are closing all issues older than 6 months as of March 1, 2023. If there are any issues or feature requests that you would like us to address, please create them according to the new templates we have created. For urgent issues, opening a support case with this link Snowflake Community is the fastest way to get a response.