snowflake-data-handling

Featured

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

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 Data Handling ## Overview Implement data governance in Snowflake using column-level masking policies, row access policies, object tagging, and data classification for GDPR/CCPA compliance. ## Prerequisites - Enterprise Edition or higher (for masking and row access policies) - SECURITYADMIN or ACCOUNTADMIN role - Understanding of GDPR/CCPA data subject rights ## Instructions ### Step 1: Data Classification with Tags ```sql -- Create tag taxonomy CREATE TAG IF NOT EXISTS pii_type ALLOWED_VALUES 'email', 'phone', 'ssn', 'name', 'address'; CREATE TAG IF NOT EXISTS data_sensitivity ALLOWED_VALUES 'public', 'internal', 'confidential', 'restricted'; -- Apply tags to columns ALTER TABLE users MODIFY COLUMN email SET TAG pii_type = 'email'; ALTER TABLE users MODIFY COLUMN phone SET TAG pii_type = 'phone'; ALTER TABLE users MODIFY COLUMN name SET TAG pii_type = 'name'; ALTER TABLE users MODIFY COLUMN email SET TAG data_sensitivity = 'confidential'; -- Find all tagged columns SELECT * FROM TABLE(INFORMATION_SCHEMA.TAG_REFERENCES( 'users', 'TABLE' )); -- Discover PII with Snowflake's automatic classification (Enterprise+) SELECT * FROM TABLE( INFORMATION_SCHEMA.EXTRACT_SEMANTIC_CATEGORIES('users') ); ``` ### Step 2: Column-Level Masking Policies ```sql -- Dynamic masking — shows real data to privileged roles, masked to others CREATE OR REPLACE MASKING POLICY email_mask AS (val STRING) RETURNS STRING -> CASE WHEN CURRENT_ROLE() IN ('DATA_ENGINEER',...

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
Data & Documents Listed

masking-pii-data

Protect personally identifiable information in data pipelines — classifying PII, choosing masking vs tokenization vs hashing vs encryption, dynamic data masking and column-level access control, and handling deletion/right-to-be-forgotten. Use when handling sensitive data, masking or anonymizing PII, meeting GDPR/CCPA/HIPAA requirements, or restricting column access in a warehouse.

27 Updated 2 months ago
Unknown-333
Data & Documents Listed

data-governance

Data lineage tracking, PII tagging, access control policies, data catalog metadata standards, retention policies, and audit logging for regulatory compliance. Use this skill whenever the company is subject to PDPA, GDPR, HIPAA, or any data privacy regulation, when an audit requires proof of who accesses what data, when PII fields need to be identified and classified in a dataset, when setting up column-level access control, or when building a data catalog. Also trigger when someone asks about data masking, anonymization, right-to-erasure workflows, role-based data access, or data lineage from source to BI tool. If the word "compliance", "audit", "PII", "sensitive data", or "regulation" appears, this skill should be active.

1 Updated 4 months ago
Methasit-Pun