Snowflake CLI¶

What is Snowflake CLI?¶

Snowflake CLI is the preferred command-line client for new installs and new work. It is an open-source command-line tool explicitly designed for developer-centric workloads in addition to SQL operations. It is a flexible and extensible tool that can accommodate modern development practices and technologies.

SnowSQL is a legacy command-line client. Snowflake will only add new features and enhancements to Snowflake CLI. Snowflake supports SnowSQL 1.5.x through April 16, 2028. If you already use SnowSQL, see Migrating from SnowSQL to Snowflake CLI.

With Snowflake CLI, developers can create, manage, update, and view apps running on Snowflake across workloads such as Streamlit in Snowflake, the Snowflake Native App Framework, Snowpark Container Services, and Snowpark. It supports a range of Snowflake features, including user-defined functions, stored procedures, Streamlit in Snowflake, and SQL execution.

What’s in this guide?¶

This guide introduces and explains how to install and use Snowflake CLI. It includes the following sections:

• Introducing Snowflake CLI
• Installing Snowflake CLI
• Configuring Snowflake CLI and connecting to Snowflake
• Bootstrapping a project from a template
• About project definition files
• Managing Snowflake objects
• Managing Snowflake stages
• Managing Snowpark Container Services in Snowflake CLI
• Using Snowpark in Snowflake CLI
• Using Snowflake Notebooks
• Managing Streamlit apps with Snowflake CLI
• Using Snowflake Native App in Snowflake CLI
• Executing SQL statements
• Managing Git repositories
• Snowflake CLI command reference

For more information about supported Snowflake products, see the following:

• Snowflake Cortex documentation
• Native App Framework documentation
• Snowflake notebooks documentation
• Snowpark Container Services documentation
• Snowpark documentation
• SQL documentation
• Git documentation
• Streamlit documentation

To see what changed in this release, see the release notes.

Snowflake CLI is an open-source project available in the Snowflake CLI Git repository.