skills.rest
d-padmanabhan
d-padmanabhanCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

snowflake

Design Snowflake RBAC, cost governance, and pipeline workflows.

15|2|Updated Dec 13, 2025
Search Tags:#rbac#data pipelines#data sharing#snowflake#warehouse cost control#permissions audit#time travel recovery
One-click install
npx skills add https://github.com/d-padmanabhan/agent-engineering-handbook --skill snowflake-d-padmanabhan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: snowflake
Source: https://github.com/d-padmanabhan/agent-engineering-handbook/tree/main/skills/snowflake
Command: npx skills add https://github.com/d-padmanabhan/agent-engineering-handbook --skill snowflake-d-padmanabhan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you design and operate Snowflake in a secure, production-grade way by preventing RBAC mistakes, controlling warehouse spend, and building reliable ingestion and recovery workflows.

Core Features & Use Cases

  • RBAC Rollout Playbook: create a role hierarchy, enforce separation of duties, and set managed access patterns for consistent permissions.
  • Cost and Performance Governance: right-size warehouses, enforce auto-suspend and resource monitors, and establish credit/storage reporting for continuous cost control.
  • Pipeline Workflows and Secure Sharing: implement Snowpipe/Streams/Tasks/Dynamic Tables patterns, set guardrails like idempotent MERGE and DLQs, and use secure data sharing with masking and row access policies.
  • Permissions Audit and Recovery: run structured grants audits and recover from bad changes using Time Travel and fail-safe recovery guidance.

Quick Start

Use the snowflake skill to produce a production-ready Snowflake RBAC rollout plan for your account, including a migration runbook away from ACCOUNTADMIN and an audit checklist for quarterly reviews.

Frequently Asked Questions about snowflake

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

FAQPage Schema
How do I set up a secure Snowflake RBAC role hierarchy and migrate away from ACCOUNTADMIN?▼

To set up secure Snowflake RBAC, create a structured role hierarchy enforcing separation of duties and managed access patterns. You can generate a production-ready rollout plan including a migration runbook away from ACCOUNTADMIN and a quarterly audit checklist.

What is the best way to control Snowflake warehouse costs and prevent credit overspend?▼

The best way to control Snowflake warehouse costs is to right-size warehouses, enforce auto-suspend rules, and configure resource monitors. This establishes continuous credit and storage reporting guardrails for ongoing cost governance.

How do I build reliable Snowflake ingestion pipelines using Snowpipe, Streams, and Tasks?▼

To build reliable Snowflake ingestion pipelines, implement Snowpipe, Streams, Tasks, and Dynamic Tables with idempotent MERGE operations. Establish pipeline observability patterns and dead-letter queues to ensure robust data processing.

Can I recover dropped or corrupted Snowflake data using Time Travel and fail-safe?▼

Yes, you can recover Snowflake data using Time Travel and fail-safe mechanisms. The skill provides structured recovery runbooks to guide restoring bad changes and returning databases to a stable state.

How do I audit Snowflake permissions and enforce secure data sharing with masking policies?▼

To audit Snowflake permissions, run structured grants audits against your role hierarchy. For secure data sharing, apply masking and row access policies to protect shared data while maintaining proper ownership conventions.

When do I need to use Dynamic Tables instead of Streams and Tasks for Snowflake data pipelines?▼

Dynamic Tables simplify Snowflake data pipelines by declaratively transforming data without manual task scheduling. Use them alongside Streams and Tasks to establish idempotent pipeline patterns and observability guardrails for complex workflows.

Related Skills

Explore More Data & Analytics Skills→
sfc-gh-miwhitakersfc-gh-miwhitaker
3

snowflake-cost-visibility

Configure Snowflake budgets, resource monitors, and role-based access control.

Community
Intermediate
snoodleboot-iosnoodleboot-io
2

compliance-automation

Automate compliance checks across systems using policy as code standards.

Official
Intermediate
yunqiqiliangyunqiqiliang
8

clickzetta-sql-pipeline-manager

Manage SQL data pipelines in ClickZetta Lakehouse with lifecycle operations.

Community
Advanced
rysweetrysweet

azure-admin

Provision users, assign RBAC, and deploy Azure resources via CLI.

Community
Advanced