snowflake-debug-bundle

Featured

Collect Snowflake debug evidence for support tickets and troubleshooting. Use when encountering persistent issues, preparing support cases, or collecting diagnostic information from QUERY_HISTORY and ACCOUNT_USAGE. Trigger with phrases like "snowflake debug", "snowflake support bundle", "snowflake diagnostic", "snowflake query history", "snowflake troubleshoot".

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 Debug Bundle ## Overview Collect diagnostic information from Snowflake's ACCOUNT_USAGE views, QUERY_HISTORY, and driver logs for support tickets and troubleshooting. ## Prerequisites - Role with access to `SNOWFLAKE.ACCOUNT_USAGE` schema (typically ACCOUNTADMIN) - Access to application logs - Permission to collect environment info ## Instructions ### Step 1: Query-Level Diagnostics ```sql -- Find the problematic query by ID SELECT query_id, query_text, execution_status, error_code, error_message, start_time, end_time, total_elapsed_time / 1000 AS elapsed_seconds, bytes_scanned, rows_produced, compilation_time, execution_time, warehouse_name, warehouse_size FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY WHERE query_id = '<paste-query-id-here>'; -- Recent failed queries SELECT query_id, query_text, error_code, error_message, start_time, user_name, role_name, warehouse_name FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY WHERE execution_status = 'FAIL' AND start_time >= DATEADD(hours, -24, CURRENT_TIMESTAMP()) ORDER BY start_time DESC LIMIT 20; -- Slow queries (> 60 seconds) SELECT query_id, query_text, total_elapsed_time / 1000 AS seconds, bytes_scanned / 1e9 AS gb_scanned, partitions_scanned, partitions_total, warehouse_name, warehouse_size FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY WHERE total_elapsed_time > 60000 AND start_time >= DATEADD(hours, -24, CURRENT_TIMESTAMP()) ORDER BY total_elapsed_time DESC LIMIT 10; ``` ...

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