embucket-labs icon indicating copy to clipboard operation
embucket-labs copied to clipboard

snowflake-rest: Add `session/heartbeat?requestId=0000-0000-000000000`

Open DanCodedThis opened this issue 3 months ago • 0 comments

  • CLIENT_SESSION_KEEP_ALIVE = true,
  • If active, it will periodically send this (with the defined frequency on the client/driver): https://github.com/snowflakedb/snowflake-connector-python/blob/main/src/snowflake/connector/network.py#L587
  • By doing this, it should keep this session alive until disconnect. After which it should stop the heartbeat.
  • This is meant for long-running queries

P.S. Reference:

  • https://github.com/snowflakedb/snowflake-connector-net/issues/590?utm_source=chatgpt.com
  • https://github.com/snowflakedb/gosnowflake/issues/1065
  • https://github.com/snowflakedb/snowflake-connector-python/blob/84fb3ed26b962d2096e8d9ab9e0718d70ac123dd/src/snowflake/connector/connection.py#L2009

DanCodedThis avatar Sep 25 '25 12:09 DanCodedThis