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

cost-management

Generate SQL queries against Snowflake ACCOUNT_USAGE views to analyze charges and credits.

Updated Mar 7, 2026
Search Tags:#sql#billing#attribution#snowflake#cost#account_usage
One-click install
npx skills add https://github.com/randoneering/nix-flake-mirror --skill cost-management-randoneering
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cost-management
Source: https://github.com/randoneering/nix-flake-mirror/tree/main/home/programs/opencode/skills/snowflake/cost-management
Command: npx skills add https://github.com/randoneering/nix-flake-mirror --skill cost-management-randoneering

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Snowflake cost-management automates analysis of charges and credits by querying ACCOUNT_USAGE billing and metering data, enabling teams to identify waste, track budgets, and optimize spend.

Core Features & Use Cases

  • Generate SQL queries against Snowflake ACCOUNT_USAGE views to surface costs, credits, and usage across warehouses, databases, and data transfers.
  • Attribute costs to teams or departments using tagging references, and monitor budget adherence with anomaly detection and cost attribution workflows.
  • Use cases include monthly spend reviews, cost-optimization initiatives, and validating chargebacks or cost allocations to projects.

Quick Start

Run a cost-analysis on the last 30 days and surface the top spenders by warehouse and database.

Frequently Asked Questions about cost-management

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

FAQPage Schema
How do I analyze Snowflake warehouse costs and credits using SQL?▼

Analyze Snowflake warehouse costs by generating SQL queries against ACCOUNT_USAGE billing and metering views to surface charges, credits, and usage across warehouses and databases.

What is the best way to attribute Snowflake billing data to specific teams?▼

Attribute Snowflake billing data to teams by leveraging tagging references within ACCOUNT_USAGE views, enabling accurate cost allocation workflows and chargeback validation for departments.

Can I detect cost anomalies and monitor budget adherence in Snowflake?▼

Yes, you can detect cost anomalies and monitor budget adherence in Snowflake by applying anomaly detection workflows to the queried metering data to identify unexpected spend spikes.

How do I generate time-bound cost reports for Snowflake storage and data transfer?▼

Generate time-bound cost reports for Snowflake storage and data transfers by querying the ACCOUNT_USAGE views with the embedded semantic model to produce clear cost insights.

Does this cost analysis approach require direct access to Snowflake metadata?▼

Yes, this cost analysis approach requires access to Snowflake ACCOUNT_USAGE views to directly query metering history, billing records, and tagging references for accurate spend attribution.

Related Skills

Explore More Finance & Accounting Skills→
miptah21miptah21
2

finding-expensive-queries

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

Community
Intermediate
ColbyRReichenbachColbyRReichenbach
1

alert-systems

Generate real-time inventory alerts for stockouts and anomalies via Redis Pub/Sub, WebSocket, and email.

Community
Advanced
wardawgmalviciouswardawgmalvicious
2

fabric-monitoring

Monitor and diagnose Fabric Warehouse queries using queryinsights schema and DMVs.

Community
Advanced
sfc-gh-samaurersfc-gh-samaurer

product_data_explorer

Classify customer questions and generate SQL queries against Snowflake data views.

Community
Intermediate