snowflake-common-errors

# 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...