Connection
snowsql -a -u -d -s -w
Connect to Snowflake using SnowSQL CLI
USE ROLE
Switch to a specific role
USE DATABASE
Switch to a specific database
USE SCHEMA
Switch to a specific schema
USE WAREHOUSE
Switch to a specific warehouse
Monitoring Queries
SELECT * FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY())
View recent query history
SELECT * FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY_BY_USER())
View query history for current user
SELECT * FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY_BY_SESSION())
View query history for current session
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY
View detailed query history with more columns
Warehouse Monitoring
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY
View warehouse credit consumption
SHOW WAREHOUSES
List all warehouses
ALTER WAREHOUSE RESUME
Resume a suspended warehouse
ALTER WAREHOUSE SUSPEND
Suspend a warehouse
User Management
SHOW USERS
List all users
SHOW ROLES
List all roles
SHOW GRANTS TO USER
Show grants for a specific user
SHOW GRANTS TO ROLE
Show grants for a specific role
Storage Monitoring
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.TABLE_STORAGE_METRICS
View storage usage by table
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.DATABASE_STORAGE_USAGE_HISTORY
View storage usage history by database
SHOW TABLES
List tables in current schema
DESCRIBE TABLE
Show table structure
Performance Analysis
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY WHERE EXECUTION_STATUS = 'FAILED'
Find failed queries
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY ORDER BY EXECUTION_TIME DESC LIMIT 10
Find slowest queries
SELECT * FROM TABLE(INFORMATION_SCHEMA.COMPLETE_TASK_GRAPHS())
View task execution graphs
Data Pipeline Monitoring
SHOW STREAMS
List all streams
SHOW TASKS
List all tasks
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.TASK_HISTORY
View task execution history
SELECT SYSTEM$STREAM_HAS_DATA('..')
Check if stream has data