Snowflake

SQL Commands

Run SQL queries and scripts directly from the command line. Execute single statements, run script files, and format output for different use cases.

6 commands

Pro Tips

Use 'snow sql -q "SELECT..."' for single queries or 'snow sql -f script.sql' for script files.

Specify output format with --format (json, csv, table) for different downstream processing needs.

Use --warehouse flag to specify compute warehouse without changing session defaults.

Common Mistakes

Large result sets can consume significant memory. Use LIMIT or stream results for big queries.

Auto-suspend warehouses may cause initial query latency. Consider warehouse resume time in automation.

Commands

Execute SQL query

$ snow sql -q "SELECT * FROM table LIMIT 10"

Execute a single SQL query.

Execute SQL file

$ snow sql -f script.sql

Execute SQL commands from a file.

SQL with JSON output

$ snow sql -q "SELECT ..." --format json

Execute query and output results as JSON.

SQL with specific warehouse

$ snow sql -q "SELECT ..." --warehouse COMPUTE_WH

Execute query using a specific warehouse.

SQL with database context

$ snow sql -q "SELECT ..." --database MY_DB --schema MY_SCHEMA

Execute query with specific database context.

SQL interactive mode

$ snow sql

Enter interactive SQL mode.