Connecting to Snowflake (SnowSQL (CLI Client)

456 viewsNative Apps FrameworkSnowsql

Connecting to Snowflake (SnowSQL (CLI Client)

Alejandro Penzini Answered question December 14, 2023

SnowSQL serves as the command-line interface for connecting to Snowflake, enabling the execution of SQL queries and performing various DDL and DML operations, including data loading and unloading from database tables.

The snowsql executable, representing SnowSQL, can operate either interactively as a shell or in batch mode through stdin or the -f option.

While SnowSQL is an application developed using the Snowflake Connector for Python, it's important to note that the connector is not mandatory for SnowSQL installation. All necessary software for SnowSQL is bundled within the installers.

Snowflake offers platform-specific versions of SnowSQL for download, catering to the following platforms:

Operating System

Supported Versions

- Linux

- CentOS 7, 8

- Red Hat Enterprise Linux (RHEL) 7, 8

- Ubuntu 16.04, 18.04, 20.04 or later

- macOS 10.14 or later

- Microsoft Windows

- Microsoft Windows 8 or later

- Microsoft Windows Server 2012, 2016, 2019, 2022

Related Videos:

How to Install, Configure & Use SnowSQL

Alejandro Penzini Answered question December 14, 2023

Maximize Your Data Potential With ITS

Feedback on Q&A