snowflake-load-scale

Featured

Implement Snowflake load testing, warehouse scaling, and capacity planning. Use when testing query performance at scale, configuring multi-cluster warehouses, or planning capacity for production Snowflake workloads. Trigger with phrases like "snowflake load test", "snowflake scale", "snowflake capacity", "snowflake benchmark", "snowflake multi-cluster".

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# Snowflake Load & Scale ## Overview Load testing, scaling strategies, and capacity planning for Snowflake workloads using warehouse sizing, multi-cluster configuration, and concurrent query simulation. ## Scaling Model | Dimension | How to Scale | When | |-----------|-------------|------| | Single query speed | Scale UP (bigger warehouse) | Complex queries, large scans | | Concurrent queries | Scale OUT (multi-cluster) | Many users, dashboard refresh | | Data volume | Scale UP + clustering | Tables > 1TB | | Mixed workloads | Separate warehouses | ETL + analytics on same data | ## Instructions ### Step 1: Benchmark Current Performance ```sql -- Baseline metrics for critical queries -- Run each query 3 times and record results -- Disable result cache for accurate benchmarking ALTER SESSION SET USE_CACHED_RESULT = FALSE; -- Test query 1: Point lookup SELECT * FROM orders WHERE order_id = 12345; -- Test query 2: Aggregation SELECT DATE_TRUNC('month', order_date) AS month, COUNT(*) AS orders, SUM(amount) AS revenue FROM orders WHERE order_date >= '2025-01-01' GROUP BY month ORDER BY month; -- Test query 3: Join + filter SELECT c.name, SUM(o.amount) AS total_spend FROM customers c JOIN orders o ON c.id = o.customer_id WHERE o.order_date >= DATEADD(days, -90, CURRENT_DATE()) GROUP BY c.name ORDER BY total_spend DESC LIMIT 100; -- Record results SELECT query_id, query_text, warehouse_name, warehouse_size, total_elapsed_time / 1000 AS seconds, bytes_...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category