---
id: snowflake-cli
version: "3.24.1"
license: Apache License Version 2.0, January 2004 http://www.apache.org/licenses/ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION 1. Definitions. "License" shall mean the terms and conditions for… (full text in the JSON record)
license_treatment: permissive
maintenance: active
---

# snowflake-cli — Snowflake CLI

License: permissive · Maintenance: active · Downloads: 1.1M/mo

## What it is and what it does

Snowflake CLI is a developer-focused command-line interface that bridges local development workflows with Snowflake's cloud data platform. It lets you build, test, and deploy applications directly from your terminal—including Streamlit apps running on Snowflake, native apps built with Snowflake's framework, Snowpark Container Services, and traditional SQL operations. The tool is designed around modern development practices and integrates with version control (via gitpython), configuration management (YAML, TOML), and templating (Jinja2).

The package pulls in a substantial dependency tree: Snowflake's own connector and Snowpark libraries, CLI frameworks (click, typer), configuration tools (pydantic, python-dotenv), and utilities for parsing and rendering (requirements-parser, rich). It runs on Python 3.10 through 3.13 and is actively maintained by Snowflake, with recent releases and community contribution pathways. The tool is positioned for developers who want to manage Snowflake workloads from the command line rather than through the web console.

Use it for:

- Deploy and manage Streamlit applications running on Snowflake without leaving your terminal.
- Create and update Snowflake Native Apps using a local development workflow with version control.
- Define and test user-defined functions and stored procedures before deploying to Snowflake.
- Execute SQL scripts and manage Snowflake objects (databases, schemas, tables) via CLI commands.
- Orchestrate Snowpark Container Services deployments as part of a CI/CD pipeline.
- Manage Snowflake configuration and secrets locally using environment files and YAML/TOML configs.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Snowflake CLI is a command-line tool for developers to create, manage, and deploy applications on Snowflake, including Streamlit apps, native apps, Snowpark services, and SQL operations.

Yes. Snowflake CLI is actively maintained, permissively licensed, has no known vulnerabilities, and installs cleanly. It is the official tool for developer-centric Snowflake workflows and is worth installing if you work with Snowflake apps, Streamlit, or Snowpark. The substantial dependency footprint is justified by its integration with Snowflake's ecosystem. Install it in an isolated environment (uv tool install or a virtual environment) to avoid conflicts.

## Install

pip install snowflake-cli
uv add snowflake-cli
poetry add snowflake-cli

## Installing snowflake-cli

Before you install: Installs cleanly with low friction; the package is actively maintained with a release 8 days old and carries 23 runtime dependencies including snowflake-connector-python and snowflake-snowpark-python. Requires Python >= 3.10.

License in practice: Licensed under Apache License 2.0, a permissive open-source license that allows commercial use, modification, and distribution with minimal restrictions—suitable for most development workflows.

Quickstart:

pip install snowflake-cli
snow --help

Requires Python >= 3.10; Snowflake account credentials must be configured (typically via environment variables or config file) to execute commands.

Verify before relying:

- Whether the CLI supports all Snowflake features mentioned (Streamlit, Native App Framework, Snowpark Container Services) equally or if some are in preview/beta.
- Performance characteristics and typical latency for common operations like app deployment or SQL execution.
- Whether all 23 runtime dependencies are required for basic usage or if some are optional for specific workloads.

## Package facts

- License: Apache License Version 2.0, January 2004 http://www.apache.org/licenses/ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION 1. Definitions. "License" shall mean the terms and conditions for… (full text in the JSON record) (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 1.1M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

snowflake command line tool, deploy streamlit to snowflake, snowflake native app framework cli, snowpark container services management, snowflake sql execution cli, snowflake developer workflow, snowflake udf and stored procedure cli, snowflake-ecosystem, cli-tool, data-platform

[View on SkillFed](https://skillfed.io/packages/snowflake-cli) · [View on PyPI](https://pypi.org/project/snowflake-cli/)