embucket-labs
embucket-labs copied to clipboard
snowflake-rest: Add `session/heartbeat?requestId=0000-0000-000000000`
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