cost-report

Name: cost-report
Availability: InStock
Author: AltimateAI

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

Ready to run

npx skills add https://github.com/AltimateAI/altimate-code --skill cost-report-altimateai

💬 Prompt for ChatGPT / Claude Chat▼

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.