snowflake-policy-guardrails

Featured

Implement Snowflake governance guardrails with network rules, session policies, authentication policies, and automated compliance checks. Use when enforcing security policies, implementing data governance, or configuring automated compliance for Snowflake. Trigger with phrases like "snowflake policy", "snowflake guardrails", "snowflake governance", "snowflake compliance", "snowflake enforce".

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# Snowflake Policy & Guardrails ## Overview Automated policy enforcement and governance guardrails using Snowflake-native features: network rules, authentication policies, session policies, and object-level governance. ## Instructions ### Step 1: Network Rules and Policies ```sql -- Network rules (more granular than legacy network policies) CREATE OR REPLACE NETWORK RULE corp_vpn_rule TYPE = IPV4 MODE = INGRESS VALUE_LIST = ('203.0.113.0/24', '198.51.100.0/24'); CREATE OR REPLACE NETWORK RULE cloud_services_rule TYPE = HOST_PORT MODE = EGRESS VALUE_LIST = ('api.company.com:443', 'events.company.com:443'); -- Create network policy using rules CREATE OR REPLACE NETWORK POLICY prod_network_policy ALLOWED_NETWORK_RULE_LIST = (corp_vpn_rule) BLOCKED_NETWORK_RULE_LIST = (); -- Apply at account level ALTER ACCOUNT SET NETWORK_POLICY = prod_network_policy; -- Or per-user (service accounts can have different rules) ALTER USER svc_etl SET NETWORK_POLICY = prod_network_policy; ``` ### Step 2: Authentication Policies ```sql -- Require MFA for interactive users CREATE OR REPLACE AUTHENTICATION POLICY interactive_auth MFA_AUTHENTICATION_METHODS = ('TOTP') CLIENT_TYPES = ('SNOWFLAKE_UI', 'SNOWSQL') SECURITY_INTEGRATIONS = ('saml_sso'); -- Service accounts: key pair only, no password CREATE OR REPLACE AUTHENTICATION POLICY service_auth AUTHENTICATION_METHODS = ('KEYPAIR') CLIENT_TYPES = ('SNOWFLAKE_DRIVER') MFA_AUTHENTICATION_METHODS = (); -- Apply po...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category