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. NoteThe 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
…with Snowflake version 8.24, network administrators have the option to require multi - factor authentication (MFA) for all connections to Snowflake. If your administrator decides to enable this feature, you must configure your client or…
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 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…
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…
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.
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 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.
Migrating from SnowSQL to Snowflake CLI
Install Snowflake CLI with your preferred method. Import your connections. Optionally check for suggested changes for your environment variables. Optionally create an alias that maps the snowsql shell command to the snow sql shell command.