Installing SnowSQL
To download the SnowSQL installer, go to the SnowSQL Download page. Note To upgrade to a new patch version, you don’t need to download and run the installer. SnowSQL upgrades itself automatically.
SnowSQL (CLI client)
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…
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.
Connecting through SnowSQL
This topic describes how to connect to Snowflake by entering connection parameters manually. The topic then explains how to configure a default connection for ease of use, as well as one or more named connections to use alternative…
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 2023
Added a new - - include_connector_version command - line option to display the version of the Snowflake Connector for Python software that is packaged in the SnowSQL binary.
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.0. Going forward, you must manually install new versions of SnowSQL. New features and updates None. Bug fixes Disabled…
Differences between sfsql and SnowSQL
SnowSQL (snowsql) provides many improvements and enhancements over the sfsql command line interface, including more intuitive option and command names. This topic lists differences in usage between the two command line clients.
Snowflake in 20 minutes
Install SnowSQL—You install and use SnowSQL, the Snowflake command line query tool. Users of Visual Studio Code might consider using the Snowflake Extension for Visual Studio Code instead of SnowSQL. Load CSV data files—You use various…