snowflake-enterprise-rbac

Featured

Configure Snowflake enterprise RBAC with system roles, custom role hierarchies, SSO/SCIM integration, and least-privilege access patterns. Use when implementing role-based access control, configuring SSO with SAML/OIDC, or setting up organization-level governance in Snowflake. Trigger with phrases like "snowflake RBAC", "snowflake roles", "snowflake SSO", "snowflake SCIM", "snowflake permissions", "snowflake access control".

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 Enterprise RBAC ## Overview Configure enterprise-grade access control using Snowflake's system-defined roles, custom role hierarchies, SSO via SAML/OIDC, and SCIM for automated user provisioning. ## Snowflake System Roles | Role | Purpose | Use For | |------|---------|---------| | ACCOUNTADMIN | Top-level admin | Billing, resource monitors, replication | | SECURITYADMIN | Security management | Users, roles, grants, network policies | | SYSADMIN | Object management | Databases, warehouses, schemas, tables | | USERADMIN | User management | Create users and roles | | PUBLIC | Default for all users | Minimal access, applied automatically | **Best Practice:** Never use ACCOUNTADMIN as a default role. Create custom roles and grant them to SYSADMIN. ## Instructions ### Step 1: Design Custom Role Hierarchy ```sql -- Functional roles (what people do) CREATE ROLE DATA_ENGINEER; CREATE ROLE DATA_ANALYST; CREATE ROLE DATA_SCIENTIST; CREATE ROLE BI_VIEWER; CREATE ROLE APP_SERVICE; -- Service accounts -- Access roles (what they can access) CREATE ROLE RAW_DATA_READER; CREATE ROLE CURATED_DATA_READER; CREATE ROLE CURATED_DATA_WRITER; CREATE ROLE GOLD_DATA_READER; -- Role hierarchy (bottom-up) -- BI_VIEWER → GOLD_DATA_READER -- DATA_ANALYST → CURATED_DATA_READER + GOLD_DATA_READER -- DATA_SCIENTIST → DATA_ANALYST + RAW_DATA_READER -- DATA_ENGINEER → all access roles -- All custom roles → SYSADMIN GRANT ROLE GOLD_DATA_READER TO ROLE BI_VIEWER; GRANT RO...

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

AI & Automation Featured

snowflake-policy-guardrails

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".

2,926 Updated yesterday
jeremylongshore
AI & Automation Featured

snowflake-data-handling

Implement Snowflake data governance with masking policies, row access policies, tagging, and GDPR/CCPA compliance patterns. Use when handling PII, implementing column masking, configuring data classification, or ensuring compliance with privacy regulations in Snowflake. Trigger with phrases like "snowflake data governance", "snowflake masking", "snowflake PII", "snowflake GDPR", "snowflake row access policy", "snowflake tags".

2,926 Updated yesterday
jeremylongshore
AI & Automation Featured

snowflake-reference-architecture

Implement Snowflake reference architecture with medallion pattern and Snowflake-native design. Use when designing a new Snowflake data platform, setting up bronze/silver/gold layers, or establishing architecture standards for a Snowflake deployment. Trigger with phrases like "snowflake architecture", "snowflake medallion", "snowflake best practices layout", "snowflake data platform design".

2,926 Updated yesterday
jeremylongshore