Source
SnowSQL (CLI client)
SnowSQL is a legacy 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.
Installing SnowSQL
To download the SnowSQL installer, go to the SnowSQL Download page. Note The SnowSQL 1.3.0 release disabled automatic upgrades, so you must manually download and reinstall for each new version. Installing SnowSQL on Linux using the…
Connecting through SnowSQL
Beginning with Snowflake version 8.24, network administrators have the option to require multi - factor authentication (MFA) for all connections to Snowflake.
Using SnowSQL
In a Snowflake session, you can issue commands to take specific actions. All commands in SnowSQL start with an exclamation point (!), followed by the command name.
SnowSQL release notes for 2023
See SnowSQL (CLI client) for documentation. Version 1.2.31 (December 13, 2023) New features and updates Added a new - - include_connector_version command - line option to display the version of the Snowflake Connector for Python software that…
Configuring SnowSQL
SnowSQL supports multiple configuration files that allow organizations to define base values for connection parameters, default settings, and variables while allowing individual users to customize their personal settings in their own…
SnowSQL Change Log (Prior to January 2022)
SnowSQL Change Log (Prior to January 2022) This topic lists the fixes, enhancements, and other changes introduced across all released, production versions of SnowSQL, the Snowflake CLI (command line interface) client prior to January 2022.
SnowSQL release notes for 2024
The SnowSQL 1.3.0 release disabled automatic upgrades. To use this version, please download and reinstall SnowSQL 1.3.
SnowSQL release notes for 2025
Added support for workload identity federation in the AWS, Azure, Google Cloud, and Kubernetes platforms. Added the workload_identity_provider connection parameter. Added WORKLOAD_IDENTITY to the values for the authenticator connection…
SnowSQL release notes for 2022
SnowSQL now captures proxies set by environment variables in logs. Bug Fixes Fixed an issue where SnowSQL returned Unicode characters as escape sequences instead of the actual Unicode characters. Removed the deprecation warning when using…