SNOW-1640968 Make connection finaliser a not blocking operation

[sfc-gh-knozderko]

Description

SNOW-1640968 Make connection finaliser a not blocking operation to avoid blocking garbage collector which could lead to massive memory consumption.

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

[codecov]

Codecov Report

Attention: Patch coverage is 94.59459% with 2 lines in your changes missing coverage. Please review.

Project coverage is 85.56%. Comparing base (3707fa0) to head (af4daf7).

Files	Patch %	Lines
Snowflake.Data/Core/Session/SFSession.cs	94.44%	1 Missing and 1 partial ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##           master    #1009      +/-   ##
==========================================
- Coverage   85.61%   85.56%   -0.06%     
==========================================
  Files         106      106              
  Lines       10777    10788      +11     
  Branches     1032     1033       +1     
==========================================
+ Hits         9227     9231       +4     
- Misses       1303     1310       +7     
  Partials      247      247              

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