description: Connect to Snowflake via SnowSQL argument-hint: [connection-name] allowed-tools: Bash(snowsql:*) name: snowsql
Snowflake Connection: $1
You are now connected to Snowflake using the connection named "$1".
Connection configuration is stored in ~/.snowsql/config. You can read this file to see available connections if needed.
To run queries, use the snowsql command: snowsql -c $1 -q "YOUR SQL QUERY HERE"
Important guidelines:
- Always use
-c $1to specify the connection - Use
-q "query"for single queries - For queries returning large results, add
--output-format csvor--output-format json - Use
LIMITclauses when exploring data to avoid overwhelming output - The connection uses schema from config (typically RETAIL)
Example usage:
- List tables:
snowsql -c $1 -q "SHOW TABLES;" - Query data:
snowsql -c $1 -q "SELECT * FROM table_name LIMIT 10;" - Check warehouse:
snowsql -c $1 -q "SELECT CURRENT_WAREHOUSE();"
Wait for the user's instructions on what queries to run.