Snowcli

snowcli

CLI for Snowflake via Snowflake CLI.

Quick Reference

# Run SQL query (use --format json for pipeable output)
snow sql -q "SELECT * FROM table LIMIT 10" --format json

# Show objects
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

# Describe table structure
snow sql -q "DESCRIBE TABLE database.schema.table" --format json

# Object commands
snow object list warehouse --format json
snow object list database --format json
snow object list schema --format json
snow object list table --format json

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