snowflake-expert

Advise on Snowflake warehouse administration, SQL optimization, and security configurations.

Updated Aug 23, 2026

Search Tags:#security #performance tuning #sql optimization #snowflake #data warehousing #cost management

Ready to run

npx skills add https://github.com/brunoldqueiroz/marvin --skill snowflake-expert-brunoldqueiroz

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: snowflake-expert
Source: https://github.com/brunoldqueiroz/marvin/tree/main/.claude/skills/snowflake-expert
Command: npx skills add https://github.com/brunoldqueiroz/marvin --skill snowflake-expert-brunoldqueiroz

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides expert guidance on optimizing Snowflake performance, managing security, and controlling costs, ensuring efficient and secure data warehousing.

Core Features & Use Cases

Warehouse Optimization: Advice on sizing, multi-clustering, and query performance.
Security & RBAC: Best practices for role-based access control and account administration.
Cost Management: Strategies for monitoring and reducing Snowflake spend.
Use Case: A user is experiencing slow query performance and high costs in their Snowflake environment. This Skill can analyze their setup and provide actionable recommendations for warehouse tuning, query optimization, and cost-saving measures.

Quick Start

Use the snowflake-expert skill to optimize warehouse sizing for BI dashboards.

Frequently Asked Questions about snowflake-expert

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

FAQPage Schema

How do I optimize slow Snowflake query performance and reduce high compute costs?▼

To optimize Snowflake query performance and reduce costs, you should analyze warehouse sizing and apply SQL tuning. Proper warehouse sizing and query optimization directly mitigate slow execution and unnecessary credit consumption.

What is the best way to set up role-based access control in Snowflake?▼

The best way to set up Snowflake role-based access control (RBAC) is to follow current security best practices for account administration. This involves structuring roles hierarchically to enforce least privilege access across your data warehousing environment.

How do I size a Snowflake warehouse for BI dashboards?▼

Sizing a Snowflake warehouse for BI dashboards requires evaluating query concurrency and workload complexity. You can select an appropriate warehouse size or implement multi-clustering to handle concurrent dashboard queries efficiently without overspending.

When should I use clustering keys in Snowflake?▼

You should use clustering keys in Snowflake when querying large tables with specific filter predicates that cause slow performance. Clustering reorganizes data to improve micro-partition pruning, significantly reducing scanned bytes and query latency.

Does Snowflake Time Travel work with streams and tasks?▼

Yes, Snowflake Time Travel works alongside streams and tasks for data replication and change data capture. Time Travel allows historical data querying, while streams track data changes to trigger automated task pipelines.

How do I handle VARIANT data in Snowflake SQL?▼

To handle VARIANT data in Snowflake SQL, you parse semi-structured JSON or XML directly using specialized functions. This allows you to extract nested values and perform SQL optimization without transforming the data into relational tables first.