Table: snowflake_session_policy - Query Snowflake Session Policies using SQL

A Snowflake Session Policy is a feature in Snowflake that allows users to define and enforce specific settings or behaviors for a user session. These policies can include setting the time zone, date and time formats, and other session parameters. Snowflake Session Policies help in maintaining consistency and control over user sessions.

Table Usage Guide

The snowflake_session_policy table provides insights into session policies within Snowflake. As a database administrator, explore specific details about each session policy, including its name, comment, and the values of the parameters it sets. Utilize it to uncover information about session policies, such as their current state, and the specific settings or behaviors they enforce.

Examples

Basic info

Identify the policies regarding session timeouts within your Snowflake environment. This can help manage idle sessions and optimize resource usage.

select
  name,
  database_name,
  schema_name,
  session_idle_timeout_mins,
  session_ui_idle_timeout_mins
from
  snowflake_session_policy;

select
  name,
  database_name,
  schema_name,
  session_idle_timeout_mins,
  session_ui_idle_timeout_mins
from
  snowflake_session_policy;

List policies with idle timeout more than an hour

Explore the policies that have an idle timeout exceeding one hour. This query can be useful in identifying potential areas for improved resource allocation and efficiency.

select
  name,
  database_name,
  schema_name,
  session_idle_timeout_mins,
  session_ui_idle_timeout_mins
from
  snowflake_session_policy
where
  session_idle_timeout_mins > 60
  or session_ui_idle_timeout_mins > 60;

select
  name,
  database_name,
  schema_name,
  session_idle_timeout_mins,
  session_ui_idle_timeout_mins
from
  snowflake_session_policy
where
  session_idle_timeout_mins > 60
  or session_ui_idle_timeout_mins > 60;

Schema for snowflake_session_policy

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account	text	The Snowflake account ID.
comment	text	Comment for this policy.
created_on	timestamp with time zone	Date and time of the creation of session policy.
database_name	text	Name of the database policy belongs.
kind	text	Type of the snowflake policy.
name	text	Identifier for the session policy.
owner	text	Name of the role that owns the policy.
region	text	The Snowflake region in which the account is located.
schema_name	text	Name of the schema in database policy belongs.
session_idle_timeout_mins	bigint	Time period in minutes of inactivity with either the web interface or a programmatic client.
session_ui_idle_timeout_mins	bigint	Time period in minutes of inactivity with the web interface.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- snowflake

You can pass the configuration to the command with the --config argument:

steampipe_export_snowflake --config '<your_config>' snowflake_session_policy