Skip to content
Back to skills

Snowflake Create Session Policy

ASecurity

Consult Snowflake CREATE SESSION POLICY parameter reference before generating any CREATE SESSION POLICY DDL.

  • 77 stars
  • 0 votes
  • 0 copies
  • 2 views
  • Added June 11, 2026
documentation

Works with

  • cli

Security analysis

A100/100

Pro scans all 2 files and shows the line behind each finding

Scanned June 11, 2026

npx -y skills add Gyrus-Dev/frosty --skill snowflake-create-session-policy --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Snowflake Create Session Policy?

Add the live security badge to your README. It updates with every re-scan.

Security grade badge for Snowflake Create Session Policy
[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/gyrus-dev-snowflake-create-session-policy/badge)](https://www.skillsdirectory.com/skills/gyrus-dev-snowflake-create-session-policy)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro
SKILL.md
---
name: snowflake-create-session-policy
description: Consult Snowflake CREATE SESSION POLICY parameter reference before generating any CREATE SESSION POLICY DDL.
---

Before writing a CREATE SESSION POLICY statement:
1. Read `references/parameters.md` to review all available parameters and their defaults.
2. For each parameter, decide whether the user's request implies a non-default value.
3. Include only the parameters that differ from the default or that the user explicitly requested.
4. Never use `CREATE OR REPLACE` — always use `CREATE SESSION POLICY IF NOT EXISTS`.
5. SESSION_IDLE_TIMEOUT_MINS applies to all Snowflake clients and programmatic connections; SESSION_UI_IDLE_TIMEOUT_MINS applies only to Snowsight. Set both when the user needs consistent behavior across interfaces.
6. BLOCKED_SECONDARY_ROLES takes precedence over ALLOWED_SECONDARY_ROLES; avoid specifying the same role in both lists.
7. Remind the user that the policy must be attached to a user or account with `ALTER USER SET SESSION_POLICY` or `ALTER ACCOUNT SET SESSION_POLICY` to take effect.

Files in this skill

  • SKILL.md1.1 KB
  • references/parameters.md2.3 KB

Attribution

Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.

Comments

Loading comments…

Newsletter

Get the weekly list of safe new skills, and the ones we pulled.