SnowSQL (CLI client)


Currently in preview, Snowflake CLI is an open-source command-line tool explicitly designed for developer-centric workloads in addition to SQL operations. As an alternative to SnowSQL, Snowflake CLI lets you execute SQL commands as well as execute commands for other Snowflake products like Streamlit in Snowflake, Snowpark Container Services, and Snowflake Native App Framework.

SnowSQL is the command line client for connecting to Snowflake to execute SQL queries and perform all DDL and DML operations, including loading data into and unloading data out of database tables.

SnowSQL (snowsql executable) can be run as an interactive shell or in batch mode through stdin or using the -f option.

SnowSQL is an example of an application developed using the Snowflake Connector for Python; however, the connector is not a prerequisite for installing SnowSQL. All required software for installing SnowSQL is bundled in the installers.

Snowflake provides platform-specific versions of SnowSQL for download for the following platforms:

Operating System

Supported Versions


CentOS 7, 8

Red Hat Enterprise Linux (RHEL) 7, 8

Ubuntu 16.04, 18.04, 20.04 or later


10.14 or later

Microsoft Windows

Microsoft Windows 8 or later

Microsoft Windows Server 2012, 2016, 2019, 2022