SNOW-2881611: Heartbeat is not using CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY parameter returned by server

[duyang76]

Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!

1. What version of .NET driver are you using?
   5.1.0

2. What operating system and processor architecture are you using?
   win x64

3. What version of .NET framework are you using?
   .Net 6

4. What did you do?
   I set CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY to 900 at USER level and connect with "CLIENT_SESSION_KEEP_ALIVE=TRUE", but Hearbeat still happens every hour

5. What did you expect to see?
   Hearbeat happens every 15m

6. Can you set logging to DEBUG and collect the logs?
   This is the log showing that the connection is idled for 1h before heartbeat

[2025-12-04 00:32:19] [1] [DEBUG] [Snowflake.Data.Core.QueryContextCache] checkCacheCapacity() returns. cacheSet size 1 cache capacity 5
null
[2025-12-04 00:32:19] [1] [DEBUG] [Snowflake.Data.Core.QueryContextCache] Cache Entry: id: 0 readTimestamp: 1764826339682179 priority: 0
null
[2025-12-04 01:32:19] [20] [DEBUG] [Snowflake.Data.Core.SFSession] heartbeat
null

[duyang76]

It seems that PR #553 addressed this issue, but it did not get merged.

[sfc-gh-dszmolka]

hi @duyang76 - indeed currently is not supported by this specific driver, is a gap compared to other Snowflake drivers.

As a workaround, you can send select 1 or similar dummy queries over the connection at any arbitrary frequency you wish, to achieve the same result of keeping the session alive.

We'll look into this if it's something the team wants to implement on a short term or what would be the planned way forward. Thank you for bearing with us; this issue will be kept updated with the progress, if any.

[duyang76]

@sfc-gh-dszmolka Thank you for the confirmation and suggestion.

This is more of a confusion than a real issue for us. During debug, we had to wait for an hour to confirm the beartbeat was running. We can wait for the fix.