SnowSQL (CLI Client)

SnowSQL is the next-generation 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

Linux

CentOS 6, 7, 8

Redhat Enterprise Linux (RHEL) 6, 7, 8

Ubuntu 16.04, 18.04 (Support for Ubuntu 14.04 is deprecated.)

macOS

10.13, 10.14, 10.15

Microsoft Windows

Windows 8, 8.1, 10 (Support for Microsoft Windows 7 is deprecated.)

Windows Server 2012, 2016, 2019

Note

The supported version numbers change over time, based largely on the evolving support policies of the operating system vendors.

Next Topics: