| name | snowcli |
| description | CLI for Snowflake. Query data, manage warehouses, databases, schemas, tables, and stages. Use when working with Snowflake data platform. |
| compatibility | Requires snow CLI (docs.snowflake.com/en/developer-guide/snowflake-cli). Needs ~/.snowflake/config.toml with connection config. |
snowcli
CLI for Snowflake via Snowflake CLI.
Quick Reference
snow sql -q "SELECT * FROM table LIMIT 10" --format json
snow sql -q "SHOW WAREHOUSES" --format json
snow sql -q "SHOW DATABASES" --format json
snow sql -q "SHOW SCHEMAS" --format json
snow sql -q "SHOW TABLES" --format json
snow sql -q "SHOW TABLES IN database.schema" --format json
snow sql -q "DESCRIBE TABLE database.schema.table" --format json
snow object list warehouse --format json
snow object list database --format json
snow object list schema --format json
snow object list table --format json
snow connection test
Output Formats
Always use --format json for agent workflows (pipeable to jq):
snow sql -q "SHOW TABLES" --format json | jq '.[].name'
snow sql -q "SELECT * FROM t" --format json | jq 'length'
Available formats: json, csv, tsv, plain, table (default).
Specifying Connection
snow sql -q "SHOW TABLES" -c connection_name
See references/setup.md for configuration and authentication.
See references/examples.md for query patterns and workflows.