snowflake-create-join-policy

SkillDatabases & data

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

Available today. Use it from your connected AI after setup.

No other account needed.

Connect ahel once, and every AI you use reads what you have installed.

Then ask your AI: use the snowflake-create-join-policy skill

What this skill tells your AI

The instructions your AI receives, as published by gyrus-dev/frosty in skills/snowflake-create-join-policy/SKILL.md and read by ahel’s review.

Before writing a CREATE JOIN POLICY statement:

Read references/parameters.md to review all available parameters and their defaults.
For each parameter, decide whether the user's request implies a non-default value.
Include only the parameters that differ from the default or that the user explicitly requested.
Never use CREATE OR REPLACE — always use CREATE JOIN POLICY IF NOT EXISTS.
The policy body must call JOIN_CONSTRAINT(JOIN_REQUIRED => <boolean_expression>). Use TRUE to enforce that queries must join to another table; use FALSE to allow unrestricted queries (equivalent to no policy).
The allowed join columns are configured when the policy is assigned to a table or view (ALTER TABLE ... SET JOIN POLICY), not in the CREATE statement itself.
The policy body cannot reference user-defined functions, tables, or views.

Advanced