snowsql

Connect to Snowflake

$ snowsql -a [account] -u [username]

$ snowsql -a [account] -u [user] -q "[SELECT * FROM table]"

$ snowsql -a [account] -u [user] -f [script.sql]

$ snowsql -a [account] -u [user] -d [database]

$ snowsql -a [account] -u [user] -w [warehouse]

$ snowsql -a [account] -u [user] -o output_format=[csv]

snowsql [-a account] [-u user] [-d database] [options]

snowsql is the official command-line client for Snowflake, a cloud-based data warehouse platform. It provides an interactive SQL shell for querying, managing databases, and performing administrative tasks on Snowflake accounts.
Connections require a Snowflake account name and credentials, which can be provided on the command line, entered interactively, or stored in a configuration file. The client supports specifying database, schema, warehouse, and role context at connection time.
SQL queries can be executed interactively in the shell, passed directly via -q, or run from script files with -f for batch automation. Output can be formatted as tables, CSV, TSV, or other formats using the -o output_format option, making it useful for data export and pipeline integration.

-a, --accountname ACCOUNT

Snowflake account.

Username.

Database.

Warehouse.

Schema.

Execute query.

Run SQL file.

Set option.

~/.snowsql/config

Connection profiles, default settings, and stored credentials for SnowSQL sessions.

Environment variable specifying the default Snowflake account name.

Requires Snowflake account. Large results may be slow. MFA may be required.

SnowSQL is the official CLI for Snowflake cloud data warehouse. It provides terminal-based access to Snowflake's SQL engine.

psql(1), mysql(1), bq(1)