otty / apps
All apps/Snowflake CLI

Snowflake CLI

snowflake-cli

A command-line interface for configuring and using Snowflake connections.

Runs as snow|macOS, Linux, Windows|docs.snowflake.com
Open form in Otty otty.toml

Command form

ai-draft · 2 tasks · 11 fields

Run a query or SQL file against a Snowflake connection. Other snow commands (apps, streamlit, stage, ...) and authentication options are left out.

Opens the form; the finished command lands at your prompt, unrun
Run in Otty
otty gui snowflake-cli

snow sql

Execute SQL

snow sql with a query, a file or standard input.

Execute SQLExample values, fixed in this page — nothing here reaches a terminal
Basic
Query*
string
Connection
string
Output format
5 choicesenum
TasksEach one presets the form for one job
Run a query
queryconnectionformat
Run a SQL file
filenameconnectionvariable
ParametersOnly these flags are editable in the form
Query
string
--query-q
SQL file
path
--filename-f
Read query from standard input
boolean
--stdin-i
Template variables
key=value
string · repeatable
--variable-D
Connection
string
--connection-c
Database
string
--database
Schema
string
--schema
Role
string
--role
Warehouse
string
--warehouse
Output format
enum
--formatTABLEJSONJSON_EXTCSVPLAIN
Single transaction
boolean
--single-transaction
SourcesEvery flag above is checked against these
snow-docs
snow sql --query, -q TEXT Query to execute. --filename, -f FILE File to execute. --stdin, -i Read the query from standard input. --variable, -D TEXT String in format of key=value. --connection, -c, --environment TEXT Name of the connection, as defined in your config.toml file. --database, --dbname TEXT --schema, --schemaname TEXT --role, --rolename TEXT --wa…
manualSnowflake CLI docs 2026-10

docs.snowflake.com

Before it fills your prompt, Otty checks the installed snow against its version. A form that does not match your version is not offered.