snowflake-common-errors

Featured

Diagnose and fix common Snowflake errors and SQL compilation failures. Use when encountering Snowflake error codes, failed queries, authentication issues, or warehouse/connection problems. Trigger with phrases like "snowflake error", "fix snowflake", "snowflake not working", "snowflake SQL error", "snowflake 002003".

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 Common Errors ## Overview Quick reference for the most common Snowflake error codes, SQL compilation errors, and driver issues with real solutions. ## Error Reference ### 002003 (42S02): Object Does Not Exist ``` SQL compilation error: Object 'MY_DB.MY_SCHEMA.USERS' does not exist or not authorized. ``` **Causes:** Table doesn't exist, wrong database/schema context, or role lacks privileges. **Solutions:** ```sql -- Check current context SELECT CURRENT_DATABASE(), CURRENT_SCHEMA(), CURRENT_ROLE(); -- Verify object exists SHOW TABLES LIKE 'USERS' IN SCHEMA MY_DB.MY_SCHEMA; -- Grant access if needed GRANT SELECT ON TABLE MY_DB.MY_SCHEMA.USERS TO ROLE MY_ROLE; -- Use fully-qualified names to avoid context issues SELECT * FROM MY_DB.MY_SCHEMA.USERS; ``` ### 000606: No Active Warehouse ``` SQL execution error: No active warehouse selected in the current session. ``` **Solutions:** ```sql -- Set warehouse for session USE WAREHOUSE COMPUTE_WH; -- Or set in connection config -- warehouse: 'COMPUTE_WH' in createConnection() -- Check warehouse state SHOW WAREHOUSES LIKE 'COMPUTE_WH'; -- If SUSPENDED, it auto-resumes if AUTO_RESUME = TRUE ``` ### 390100: Incorrect Username or Password ``` Incorrect username or password was specified. ``` **Solutions:** ```bash # Verify credentials are set echo $SNOWFLAKE_ACCOUNT # Should be 'orgname-accountname' echo $SNOWFLAKE_USER # Test with SnowSQL snowsql -a $SNOWFLAKE_ACCOUNT -u $SNOWFLAKE_USER # Check account form...

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