pii-handling

Identify and classify PII in Snowflake and dbt workflows.

1|1|Updated Feb 27, 2026
One-click install
npx skills add https://github.com/nrakow/ae-skills-dev --skill pii-handling
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: pii-handling
Source: https://github.com/nrakow/ae-skills-dev/tree/main/skills/pii-handling
Command: npx skills add https://github.com/nrakow/ae-skills-dev --skill pii-handling

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Identify, classify, and protect personal data across analytics pipelines to meet GDPR, CCPA, and HIPAA compliance, reducing risk of exposure and regulatory fines.

Core Features & Use Cases

  • Automated PII discovery in Snowflake/dbt, tagging and lineage tracking
  • Pseudonymization and masking macros for safe analytics in dev, with DSAR-ready workflows
  • retention policy guidance, auditing checklists, and PHI/PII governance documentation

Quick Start

Run the data-stack-context to capture your environment and enable PII protection across projects.

Frequently Asked Questions about pii-handling

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I identify and classify PII across my Snowflake and dbt analytics pipelines?

To identify and classify PII across Snowflake and dbt pipelines, you apply dbt tagging for PII fields and run automated discovery to track data lineage. This enables compliant data handling and reduces exposure risk across your environments.

What is the best way to mask or pseudonymize data for safe analytics in development environments?

The best way to pseudonymize data for development environments is by applying reusable masking and pseudonymization macros in dbt. This ensures safe analytics by obscuring original values while maintaining referential integrity for testing.

Can I use dbt tagging to support GDPR and CCPA retention policies and DSAR readiness?

Yes, you can use dbt tagging to support GDPR and CCPA compliance by enabling DSAR-ready workflows. This approach provides retention policy guidance and auditing checklists to track personal data lineage across your analytics stack.

How do I audit my data assets for PHI and PII governance documentation?

To audit data assets for PHI and PII governance, you utilize a PII audit checklist and testing routines integrated with your data-stack-context. This validates masking policies and produces governance documentation for regulatory compliance.

Do I need to configure my data-stack-context before applying PII protection across projects?

Yes, you need to configure the data-stack-context to capture your environment before applying PII protection. This setup step is required to correctly identify personal data and enable consistent masking across all development and production projects.