snowsql

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.

Default role to use.

Use a named connection from config file.

Define a variable (referenced as &KEY in queries).

Set option (e.g., output_format=csv, quiet=true, friendly=false).

Display SnowSQL version.

Force upgrade to latest SnowSQL version.

Path to configuration file.

~/.snowsql/config

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

Environment variable specifying the default Snowflake account name.

Environment variable specifying the default password.

Environment variable specifying the default role.

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)