CODEWITHSUNDEEP
snowflake-cloud-data-platform
GriGrim
GriGrim

Reputation: 2921

Snowflake UI sessions are not killed after 4 hours

I know that there is user parameter CLIENT_SESSION_KEEP_ALIVE, which defines wether session should stay alive forever or be killed after 4 hours of inactivity.

Mine is set to False.

show parameters like 'CLIENT_SESSION_KEEP_ALIVE';

But in Snowflake UI on tab Account > Sessions I see my old session, which started almost 2 days ago.

When I check this session in QUERY_HISTORY table, I also see that there were no queries for almost 2 days.

Why my session is not getting killed? Which settings should I change?

If there is no way to kill such sessions automatically, then I'd like to kill them manually using select system$abort_session(<session_id>); command.

In order to do that, first of all I need to get list of active sessions, that I see on UI tab Account > Sessions.

Is there any system table/view which can provide such data?

Upvotes: 2

Views: 1823

Answers (1)

Mike Walton
Mike Walton

Reputation: 7339

Per the Snowflake Documentation, the CLIENT_SESSION_KEEP_ALIVE is only for ODBC, JDBC, Python, and Node.JS client connectors. It does not affect the UI.

https://docs.snowflake.com/en/sql-reference/parameters.html#client-session-keep-alive

Upvotes: 2

Related Questions