skills.rest
AltimateAI
AltimateAIOFFICIAL
Explore all skills by this author →
WebsiteGitHub

cost-report

Analyze Snowflake credits, queries, users, and warehouses to identify cost hotspots.

792|138|Updated Feb 27, 2026
Search Tags:#cost-optimization#finops#warehouse#snowflake#cost#query-analysis
One-click install
npx skills add https://github.com/AltimateAI/altimate-code --skill cost-report-altimateai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cost-report
Source: https://github.com/AltimateAI/altimate-code/tree/main/.opencode/skills/cost-report
Command: npx skills add https://github.com/AltimateAI/altimate-code --skill cost-report-altimateai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Identify and reduce Snowflake query costs by surfacing expensive queries, anti-patterns, and inefficient warehouse configurations to optimize spend.

Core Features & Use Cases

  • Top-cost query identification: Surface the most expensive queries by credits used in the last 30 days.
  • Cost breakdown by user, warehouse, and query type: Understand who or what is driving spend.
  • Optimization recommendations: Propose warehouse resizing, query tuning, and caching opportunities.
  • Use Case: A data analytics team performs monthly cost visibility and targeted optimizations across Snowflake warehouses.

Quick Start

Invoke /cost-report to generate a 30-day cost analysis and actionable optimization recommendations.

Frequently Asked Questions about cost-report

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

FAQPage Schema
How do I identify expensive Snowflake queries for cost optimization?▼

To identify expensive Snowflake queries for cost optimization, you can analyze account usage data to surface the most costly queries by credits used over a 30-day period. This process highlights specific query anti-patterns driving up compute spend.

How do I analyze Snowflake warehouse usage to reduce compute costs?▼

Analyzing Snowflake warehouse usage involves reviewing credits consumed per warehouse to detect inefficient configurations and sizing. This analysis generates actionable recommendations like warehouse resizing and caching opportunities to directly reduce compute costs.

Can I break down Snowflake costs by user and query type?▼

Yes, you can break down Snowflake costs by user and query type by analyzing account usage data. This generates per-user, per-warehouse, and per-query-type insights to clarify exactly who and what is driving your monthly compute spend.

What is the best way to perform a monthly Snowflake cost review?▼

The best way to perform a monthly Snowflake cost review is to analyze credits, query text, and user data across multiple warehouses. This surfaces cost hotspots and produces structured markdown reports with targeted optimization recommendations.

What Snowflake account access is required to detect query anti-patterns?▼

Detecting query anti-patterns requires access to Snowflake account usage data. You need this access to run queries and use analytical tools that evaluate query history, credits used, and warehouse configurations for optimization opportunities.

Related Skills

Explore More Data & Analytics Skills→
victormacaubasvictormacaubas
1

data-governance

Query Snowflake ACCOUNT_USAGE views for governance and compliance inquiries.

Community
Advanced
hiddink-aihiddink-ai
1

snowflake-best-practices

Optimize Snowflake warehouse sizing, clustering, caching, and query performance.

Official
Intermediate
miptah21miptah21
2

finding-expensive-queries

Rank Snowflake queries by execution cost, time, and data scanned.

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

cortex-ai-cost-controls

Manage and visualize AI cost metrics in a Snowflake-based Streamlit dashboard.

Community
Advanced