{"id":10237,"library":"snowflake-cli-labs","title":"Snowflake CLI","description":"The `snowflake-cli-labs` package provides the official Snowflake Command Line Interface (CLI), a powerful tool for interacting with Snowflake accounts, managing objects, and deploying applications like Snowpark Container Services or Streamlit apps. It's developed by Snowflake-Labs, with version 3.16.0 currently active. Releases typically align with Snowflake platform updates and feature developments.","status":"active","version":"3.16.0","language":"python","source_language":"en","source_url":"https://github.com/Snowflake-Labs/snowflake-cli","tags":["snowflake","cli","data-engineering","cloud","data-warehouse","devops"],"install":[{"cmd":"pip install snowflake-cli-labs","lang":"bash","label":"Install latest version"}],"dependencies":[{"reason":"Requires Python 3.10 or newer.","package":"python","optional":false}],"imports":[{"note":"The `snowflake-cli-labs` package is primarily a command-line interface tool, exposing the `snow` command. Direct programmatic import of its components is uncommon for general use. For advanced scenarios (e.g., testing or building custom commands/extensions), the internal Python module is `snowcli`.","wrong":"from snowflake_cli_labs import app","symbol":"app","correct":"from snowcli.cli_app import app"}],"quickstart":{"code":"# 1. Verify installation and see available commands\nsnow --help\n\n# 2. Add a new connection profile (replace with your details)\n# This will prompt for your Snowflake account URL, username, and password.\n# The 'default' profile is used if no other is specified.\nsnow connection add --name default\n\n# 3. List existing connection profiles\nsnow connection list\n\n# 4. Run a simple SQL query\nsnow sql -q \"SELECT current_version();\"","lang":"bash","description":"The Snowflake CLI is primarily used via the `snow` command in your terminal. This quickstart demonstrates verifying installation, configuring a connection, and running a basic SQL query."},"warnings":[{"fix":"Uninstall the old `snowcli` if present, then `pip install snowflake-cli-labs`. Review the migration guide for specific command changes and `project.toml` schema updates.","message":"The `snowflake-cli-labs` package is the official successor to the older, standalone `snowcli` (pre-v1.0). Users of the legacy `snowcli` must migrate, as commands, configurations, and functionalities may differ significantly.","severity":"breaking","affected_versions":"< 1.0 (legacy snowcli)"},{"fix":"Use `snow connection add --help` to understand available options. Ensure your account locator, username, and authentication method (e.g., browser popup, `SNOWFLAKE_PASSWORD` environment variable, or key file path) are correctly configured for your chosen profile.","message":"Connection authentication methods and profile management can be a common source of issues. The CLI supports browser-based, username/password, and key-pair authentication, each with specific setup requirements.","severity":"gotcha","affected_versions":"All versions"},{"fix":"Always refer to the official Snowflake CLI documentation for the current `project.toml` schema when upgrading your CLI or migrating existing projects. You may need to update section names, properties, or file paths.","message":"The schema for `project.toml` files, used for deploying Snowpark applications, Streamlit apps, or other Snowflake objects, can change between major CLI versions. This may require manual updates to your project definitions.","severity":"breaking","affected_versions":"All major versions (e.g., 2.x to 3.x)"}],"env_vars":null,"search_vec":"'3.16.0':46 'account':24 'activ':48 'align':51 'app':36 'applic':29 'cli':2,6,16,60 'cloud':64 'command':13 'contain':32 'current':47 'data':62,66 'data-engin':61 'data-warehous':65 'deploy':28 'develop':39,58 'devop':68 'engin':63 'featur':57 'interact':21 'interfac':15 'lab':7,43 'like':30 'line':14 'manag':25 'object':26 'offici':11 'packag':8 'platform':54 'power':18 'provid':9 'releas':49 'servic':33 'snowflak':1,5,12,23,42,53,59 'snowflake-cli-lab':4 'snowflake-lab':41 'snowpark':31 'streamlit':35 'tool':19 'typic':50 'updat':55 'version':45 'warehous':67","created_at":"2026-04-17T01:23:05.329470+00:00","updated_at":"2026-04-17T01:23:05.329470+00:00","problems":{"verify_error":"Traceback (most recent call last):\n  File \"<string>\", line 1, in <module>\nModuleNotFoundError: No module named 'snowcli'"},"ecosystem":"pypi","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":"3.20.0","cli_name":"snow","cli_version":"Snowflake CLI version: 3.17.1","type":"library","homepage":"https://docs.snowflake.com/en/developer-guide/snowflake-cli-v2/index","github":"https://github.com/snowflakedb/snowflake-cli","docs":null,"changelog":null,"pypi":"https://pypi.org/project/snowflake-cli-labs/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["devops","database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":"skip","verified_at":"2026-06-28","last_verified":"2026-06-28","next_check":"2026-08-01","install_tag":null}}