skills.rest
victormacaubas
victormacaubasCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

data-governance

Query Snowflake ACCOUNT_USAGE views for governance and compliance inquiries.

1|Updated May 19, 2026
Search Tags:#access control#data governance#snowflake#security auditing#account usage
One-click install
npx skills add https://github.com/victormacaubas/data-engineering-skills --skill data-governance-victormacaubas
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-governance
Source: https://github.com/victormacaubas/data-engineering-skills/tree/main/skills/data-governance
Command: npx skills add https://github.com/victormacaubas/data-engineering-skills --skill data-governance-victormacaubas

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines inquiries about Snowflake governance, security posture, data access patterns, policy coverage, role analysis, user auditing, classification status, and querying Snowflake's ACCOUNT_USAGE views.

Core Features & Use Cases

  • Snowflake Governance Queries: Perform detailed queries on SNOWFLAKE.ACCOUNT_USAGE for governance, security, and compliance.
  • Real-time vs Historical Data: Access both real-time and historical data based on user requirements.
  • Data Classification and Tagging: Query information on Snowflake data classification, tagging, and policy enforcement.
  • Access Control and Security Auditing: Monitor access patterns and security events.
  • Use Case: When a user needs to understand who accessed sensitive data, what data is classified, or how data access policies are enforced in Snowflake.

Quick Start

Use the data-governance skill to query the current roles and their grants with the following command: show grants to role all.

Frequently Asked Questions about data-governance

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

FAQPage Schema
How do I audit data access patterns in Snowflake for compliance?▼

You can audit data access patterns by querying Snowflake's `ACCOUNT_USAGE` views to monitor security events and track who accessed sensitive data. This Skill handles both current state and historical compliance inquiries.

Can I check data classification and tagging status in Snowflake?▼

Yes, you can check data classification and tagging status by querying Snowflake's `ACCOUNT_USAGE` views. This retrieves information on classification, tagging, and policy enforcement to support data governance inquiries.

What permissions do I need to query Snowflake account usage views for governance?▼

Querying Snowflake account usage views for governance requires relevant permissions to access the `ACCOUNT_USAGE` schema. You need an environment with the appropriate roles enabled to query security and access data.

Does this approach support historical data analysis for Snowflake security auditing?▼

Yes, this approach supports historical data analysis for Snowflake security auditing. It queries `ACCOUNT_USAGE` views to access both real-time and historical data based on your specific compliance requirements.

How do I list all role grants in Snowflake for access control analysis?▼

To list all role grants in Snowflake for access control analysis, use the command `show grants to role all`. This queries the current roles and their associated grants to support data governance and compliance inquiries.

Related Skills

Explore More Data & Analytics Skills→
randoneeringrandoneering

data-governance

Generate governance SQL queries against Snowflake ACCOUNT_USAGE views.

Community
Advanced
aws-samplesaws-samples
43

generate-preventive

Generate AWS security control artifacts from JSON mapping and validation results.

Official
Advanced
tomztomz

azure-purview

Automate Microsoft Purview governance setup for data cataloging, lineage, and compliance.

Community
Advanced
krzemienskikrzemienski
2

security-pattern-detection

Detect OWASP Top 10 vulnerabilities via static analysis and generate remediation examples.

Community
Advanced