snowflake-cli
Snowflake CLI
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python >= 3.10; Snowflake account credentials must be configured (typically via environment variables or config file) to execute commands.
- 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 · maintenance · safety
permissive license (permissive) — 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.
last release 2026-08-06 (8 days) · last repo commit 2026-08-14 · 266 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 1,091,895 downloads/mo, #4,378 on PyPI
Alternatives
Verify before relying
pip install snowflake-cli
snow --help- 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.
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 on this page. Verify before relying on it.
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
snowflake-cli on PyPI
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.
Requires Python >= 3.10; Snowflake account credentials must be configured (typically via environment variables or config file) to execute commands.
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 --helpVerify 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 | permissive license permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 23 packagesclickgitpythonidjinja2packagingpippluggyprompt-toolkitprotobufpydanticpython-dotenvpyyamlrequestsrequirements-parserrichsetuptoolssnowflake-connector-pythonsnowflake-coresnowflake-snowpark-pythontomlkittyperurllib3websocket-client |
| Maintenance | Actively maintained 8 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 1,091,895 / month, #4,378 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableEnvironment :: ConsoleIntended Audience :: DevelopersIntended Audience :: Information TechnologyIntended Audience :: System AdministratorsLicense :: OSI Approved :: Apache Software LicenseProgramming Language :: Python :: 3Programming Language :: Python :: 3 :: OnlyProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: SQLTopic :: Database |
Evidence: snowflake_cli-3.24.1-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “deploy streamlit to snowflake”
- snowflake-cliSnowflake CLI is a command-line tool for developers to create,…
- pulumi-snowflakeA Pulumi resource provider that lets you define, deploy, and manage…
- snowflake-ml-pythonSnowflake ML Python provides SDKs and infrastructure to build, train,…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also snowflake-cli-labs · snowpark-connect · snowflake-snowpark-python · snowflake · fakesnow · meltanolabs-target-snowflake · snowflake-id · snowflake-telemetry-python · django-snowflake · datacontract-cli