skills.rest
randoneering
randoneeringCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

data-governance

Generate governance SQL queries against Snowflake ACCOUNT_USAGE views.

Updated Mar 7, 2026
Search Tags:#permissions#compliance#auditing#classification#snowflake#data-governance#account_usage
One-click install
npx skills add https://github.com/randoneering/nix-flake-mirror --skill data-governance-randoneering
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-governance
Source: https://github.com/randoneering/nix-flake-mirror/tree/main/.claude/skills/dbt/data-governance
Command: npx skills add https://github.com/randoneering/nix-flake-mirror --skill data-governance-randoneering

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill enables data teams to rapidly generate governance SQL against Snowflake ACCOUNT_USAGE to surface access patterns, role hygiene, and policy compliance.

Core Features & Use Cases

  • Generate SQL for user access auditing, role analysis, and policy evaluation across Snowflake accounts.
  • Classify data and identify sensitive columns, masking policies, and data lineage through ACCOUNT_USAGE views.
  • Use cases include: auditing who accessed what, reviewing grants to roles/users, and ensuring policy compliance across production environments.

Quick Start

Ask me to generate governance queries against Snowflake ACCOUNT_USAGE to audit access, roles, and data classifications.

Frequently Asked Questions about data-governance

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

FAQPage Schema
How do I audit user access and permissions in Snowflake ACCOUNT_USAGE?▼

To audit user access and permissions in Snowflake ACCOUNT_USAGE, you can generate governance SQL queries that surface access patterns, role hygiene, and policy compliance across your accounts.

What is the best way to review role hygiene and grants in Snowflake?▼

Reviewing role hygiene and grants in Snowflake involves generating SQL against ACCOUNT_USAGE views to analyze role assignments, evaluate policy compliance, and identify sensitive columns.

Can I query data classification and masking policies using Snowflake ACCOUNT_USAGE?▼

Yes, you can query data classification and masking policies using Snowflake ACCOUNT_USAGE by generating SQL that identifies sensitive columns and evaluates policy compliance.

How do I handle JSON fields in Snowflake ACCOUNT_USAGE governance views?▼

Handling JSON fields in Snowflake ACCOUNT_USAGE governance views requires using LATERAL FLATTEN in your SQL queries to parse nested data and return results suitable for governance dashboards.

Does this approach support compliance reporting across multiple Snowflake accounts?▼

Yes, this approach supports compliance reporting across multiple Snowflake accounts by generating governance SQL queries that audit user access, permissions, and policy compliance.

Why are my Snowflake data governance dashboards not showing accurate access patterns?▼

Snowflake data governance dashboards may not show accurate access patterns if your SQL queries do not properly use LATERAL FLATTEN to parse JSON fields or fail to fully query ACCOUNT_USAGE views.

Related Skills

Explore More Data & Analytics Skills→
randoneeringrandoneering

semantic-view-creation

Create semantic views from SQL queries and Snowflake metadata via FastGen API.

Community
Advanced
iTzFaisaliTzFaisal
1

revops

Automate revenue operations design and governance across marketing, sales, and customer success.

Community
Advanced
DKSangDKSang
2

des-persona-governance-reviewer

Evaluate data lineage, metadata stewardship, access control, and privacy handling for governance compliance.

Community
Intermediate
sfc-gh-miwhitakersfc-gh-miwhitaker
3

msp-provider

Guide multi-tenant Snowflake setup with vendor Snowsight and managed access schema.

Community
Advanced