SNOW-860872 connection pool

[sfc-gh-knozderko]

Description

New connection pool.

Checklist

• Code compiles correctly
• Code is formatted according to Coding Conventions
• Created tests which fail without the change (if possible)
• All tests passing (dotnet test)
• Extended the README / documentation, if necessary
• Provide JIRA issue id (if possible) or GitHub issue id in PR name

[gitguardian]

⚠️ GitGuardian has uncovered 2 secrets following the scan of your pull request.

Please consider investigating the findings and remediating the incidents. Failure to do so may lead to compromising the associated services or software components.

🔎 Detected hardcoded secrets in your pull request

GitGuardian id	GitGuardian status	Secret	Commit	Filename
9511947	Triggered	ODBC Connection String	5a3c451	Snowflake.Data.Tests/UnitTests/SFOktaTest.cs	View secret
9511947	Triggered	ODBC Connection String	5a3c451	Snowflake.Data.Tests/UnitTests/SFOktaTest.cs	View secret

🛠 Guidelines to remediate hardcoded secrets

The above secret(s) have been detected in your PR. Please take an appropriate action for each secret:

• If it’s a true positive, remove the secret from source code, revoke it and migrate to a secure way of storing and accessing secrets (see http://go/secrets-and-code). Once that’s done, go to the incidents page linked in the “GitGuardian id” column (log in using SnowBiz Okta) and resolve the incident.
• If it’s a false positive, go to the incidents page linked in the “GitGuardian id” column (log in using SnowBiz Okta) and ignore the incident.
• If you didn't add this secret - and only then - you may ignore this check as it's non-blocking. If you did add the secret and you ignore this check, you'll be assigned a "Security Finding" ticket in Jira in a few days.

Note:

• A secret is considered leaked from the moment it touches GitHub. Rewriting git history by force pushing or other means is not necessary and doesn’t change the fact that the secret has to be revoked.
• This check has a “Skip: false positive” button. Don’t use it. It will mark all detected secrets as false positives but only in the context of this specific run - it won’t remember this action in subsequent check runs.

If you encounter any problems you can reach out to us on Slack: #gitguardian-secret-scanning-help

---

^{🦉 GitGuardian detects secrets in your source code to help developers and security teams secure the modern development process. You are seeing this because you or someone else with access to this repository has authorized GitGuardian to scan your pull request.}

[codecov]

Codecov Report

Attention: Patch coverage is 93.11520% with 101 lines in your changes missing coverage. Please review.

Project coverage is 85.09%. Comparing base (d158fd4) to head (3951612).

❗ Current head 3951612 differs from pull request most recent head 53f74be

Please upload reports for the commit 53f74be to get more accurate results.

Files	Patch %	Lines
Snowflake.Data/Core/Session/SessionPool.cs	92.75%	21 Missing and 9 partials ⚠️
Snowflake.Data/Core/SFResultSet.cs	91.54%	15 Missing and 2 partials ⚠️
Snowflake.Data/Client/SnowflakeDbSessionPool.cs	27.27%	7 Missing and 1 partial ⚠️
...ke.Data/Core/Authenticator/KeyPairAuthenticator.cs	0.00%	7 Missing ⚠️
Snowflake.Data/Core/Session/SFSession.cs	87.50%	5 Missing and 2 partials ⚠️
Snowflake.Data/Client/SnowflakeDbConnectionPool.cs	90.62%	4 Missing and 2 partials ⚠️
...Data/Core/Session/SFSessionHttpClientProperties.cs	95.00%	4 Missing and 2 partials ⚠️
Snowflake.Data/Core/Session/WaitingQueue.cs	94.38%	3 Missing and 2 partials ⚠️
...owflake.Data/Core/Session/ConnectionPoolManager.cs	95.50%	2 Missing and 2 partials ⚠️
...flake.Data/Core/Session/SessionOrCreationTokens.cs	82.60%	2 Missing and 2 partials ⚠️
... and 4 more

Additional details and impacted files

@@            Coverage Diff             @@
##           master     #955      +/-   ##
==========================================
+ Coverage   84.74%   85.09%   +0.34%     
==========================================
  Files          89      106      +17     
  Lines        9709    10759    +1050     
  Branches      921     1029     +108     
==========================================
+ Hits         8228     9155     +927     
- Misses       1253     1355     +102     
- Partials      228      249      +21     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.