Skip to main content

Session Management & Troubleshooting

Proper session management and troubleshooting are critical skills for a Snowflake Administrator. This module covers how to monitor, manage, and resolve issues related to active sessions, blocked queries, and resource contention.

Key Topics​

  • Session Policies: Controlling idle timeouts, authentication policies, and UI sessions.
  • Monitoring Active Sessions: Using SHOW SESSIONS and the SESSIONS view in ACCOUNT_USAGE to audit user activity.
  • Troubleshooting Blocked Queries: Identifying locks, analyzing transaction history, and resolving deadlocks.
  • Terminating Queries: Best practices for using SYSTEM$CANCEL_QUERY and SYSTEM$ABORT_SESSION.