| Task | Command |
|---|---|
| List databases | SHOW DATABASES; |
| Use database | USE DATABASE my_db; |
| List schemas | SHOW SCHEMAS IN my_db; |
| List tables | SHOW TABLES IN my_db.my_schema; |
| Describe table | DESC TABLE my_table; |
| List stages | SHOW STAGES; |
| List warehouses | SHOW WAREHOUSES; |
| Show current role | SELECT CURRENT_ROLE(); |
| Show current warehouse | SELECT CURRENT_WAREHOUSE(); |