Backward incompatibility

Deprecations

New additions

• snow connection add now supports --client-store-temporary-credential, which writes client_store_temporary_credential = true to the new connection in config.toml.
• snow sql --local-only default can now be set via the SNOWFLAKE_CLI_SQL_LOCAL_ONLY environment variable. Accepted values: 1/true/yes/on (enable) and 0/false/no/off (disable). When unset, the default remains false.
• The snow app commands now support an app.yml (version 2) for Snowflake App Runtime projects; when present it drives the flow instead of snowflake.yml (the Native App flow is unchanged). Its targets block declares named per-environment deployments, and a new --target flag on deploy, open, events, teardown, and validate selects which one to use. snow app deploy runs an upload → build → deploy pipeline that can be limited to a single phase with --upload-only, --build-only, or --promote-only.

Fixes and improvements

• snow app events for Snowflake App Runtime projects can now return more events by requesting a higher --last value.
• snow app deploy with workspace-backed storage now builds from versions/live/ (the current working state) instead of the last committed version. In the Workspaces editor, files auto-save to the live version continuously — reading versions/last during the build phase caused stale content to be deployed when running from a live workspace session.
• DCM projects: the snow dcm preview, snow dcm refresh, and snow dcm test commands are not yet generally available. They are now hidden from --help unless the enable_dcm_preview_features CLI feature flag is enabled, so they no longer appear in snow dcm --help without an explicit opt-in.
• snow streamlit deploy --replace: fixed a crash when replacing a legacy ROOT_LOCATION Streamlit app with a versioned deployment.
• Upgraded GitPython from 3.1.57 to 3.1.58.

v3.24.1

Fixes and improvements

• DCM projects: the --env-file/-e option for sourcing declared templating.env_vars/templating.env_secrets values from a .env file is not yet generally available. It is now hidden from --help unless the enable_dcm_project_env_vars CLI feature flag is enabled. This fixes a bug introduced in v3.24.0, where the option was visible without requiring any opt-in.

v3.24.0

Backward incompatibility

• snow app commands for Snowflake App Runtime projects now always operate on APPLICATION SERVICE objects and no longer fall back to plain SPCS SERVICE objects. snow app open --settings always uses the app-service Snowsight URL segment, and snow app teardown always drops and verifies the app via APPLICATION SERVICE. Apps still deployed as legacy SPCS services are no longer supported by these commands.

Deprecations

New additions

• Added optional --validation-profile to snow spcs service remote-build (e.g. ML_JOB, NOTEBOOK). The value is forwarded as validation_profile on POST /api/v2/remote-build/execute so the image builder can select a pre-baked validation ruleset. When omitted, no image validation is requested. Ignored for --build-type app.
• Added snow spcs service remote-build, remote-build-status, and remote-build-history commands that submit and track SPCS image/app builds via the remote build REST API. These commands are hidden by default and gated by the enable_spcs_remote_build CLI feature flag.
• snow dcm plan now supports the --delta flag for incremental deployments. This option enables processing only statements that have changed since the last deploy, plus statements potentially impacted by those changes.
• snow dcm commands are now generally available (GA). DCM provides infrastructure-as-code capabilities for managing Snowflake objects through declarative SQL files. All DCM commands are now available without needing to enable the enable_snowflake_projects feature flag.
• DCM projects: snow dcm deploy, snow dcm plan, and snow dcm preview now support environment variables and secrets declared in a project manifest's templating.env_vars/templating.env_secrets sections. Declared values are collected from the shell environment, or from a .env file passed via --env-file/-e (the shell always wins for a name declared in both), and forwarded to the server.
• Added snow helpers check-version, which reports the installed Snowflake CLI version alongside the latest published version and whether an upgrade is available. Use --refresh to bypass the local cache and query PyPI/Homebrew directly. This is the on-demand equivalent of the automatic upgrade banner and always reports its result, even when ignore_new_version_warning is set.
• Added snow dbt copy, which copies files between a local directory and a stage (or between stages) for a dbt project. It is an alias of snow stage copy and supports the same paths and options (--recursive, --overwrite, --parallel, --auto-compress, --refresh).
• snow app events now surfaces app health telemetry for Snowflake App Runtime projects. --type log|metric|lifecycle selects the stream (default log); --since / --until accept relative shorthand (e.g. 30m, 6h, 2d) or absolute UTC timestamps and switch logs to the historical event table, while metric and lifecycle are always historical and default to the last hour. --metric cpu|memory|network narrows metric output and --raw emits unconverted values (bytes, cores). The bare snow app events live log tail is unchanged.
• snow dcm deploy, snow dcm purge, snow dcm plan, snow dcm preview, snow dcm refresh, and snow dcm test now show live, per-step progress as an interactive checklist instead of a single generic spinner.

Fixes and improvements

• snow dcm commands now summarize the files being uploaded as a tree beneath the upload step, instead of listing every file on its own line.
• Recursive stage uploads now upload directories concurrently instead of one at a time. This applies to every command that uploads a directory tree to a stage (e.g. snow stage copy --recursive, snow dcm deploy, snow dcm plan, snow dbt deploy, snow spcs service build-image). Upload wall-clock is dominated by per-PUT round-trip latency, so trees with many nested folders (e.g. one file per directory) see a large speedup. Total upload concurrency is bounded by the SNOWFLAKE_CLI_STAGE_UPLOAD_WORKERS setting (config key cli.stage_upload_workers, default 16; set to 1 to restore the previous serial behavior). For snow stage copy this budget is shared with --parallel rather than multiplied by it, so existing invocations do not spawn more threads than before.
• snow dcm plan, deploy, and purge now render each altered object's changes as an indented tree, showing added, modified, and removed columns, constraints, grants, and other properties — with previous → new values — instead of only the object name. Long or multi-line values are collapsed to a single line.
• A bare USER$ database resolved from the active connection is now expanded to the caller's personal database (USER$<username>) when the connection specifies a username, so commands validate and report against the fully-qualified name.
• snow app commands (validate, open, events, deploy, teardown) now resolve their database and schema from the active connection like other CLI commands, so a bare USER$ database configured in snowflake.yml is expanded to the caller's personal database.
• snow app setup now defaults to a workspace for code storage on all databases (previously regular databases used a stage). When the role cannot create a workspace it uses a stage instead, and snow app deploy also falls back to a stage if a workspace cannot be used.
• Upgraded GitPython from 3.1.50 to 3.1.57.
• snow dcm commands run with --save-output now write artifacts directly into the out/ directory, with each command's response in out/<command>_result.json, instead of nesting them under a per-command subdirectory. The out/ directory is recreated empty at the start of every such run.

v3.23.0

Deprecations

New additions

• snow spcs service events is now generally available. This command returns service-level and service-instance-level platform events in addition to container-level events.
• snow app open now accepts a --watch flag for Snowflake App Runtime projects. With --watch, the command no longer fails when the app service does not exist yet; it polls until the service is created and its endpoint is ready before opening (or printing) the URL.
• snow app --help is now context-aware: when the current project's snowflake.yml unambiguously targets one app family (Native Apps or Snowflake App Runtime), the help listing hides the other family's commands. Detection is conservative — a mixed, missing, or unparsable project shows every command — and hidden commands remain fully runnable. Because the same filtering backs shell completion and Click's "did you mean" suggestions, the hidden family's commands also stop appearing in snow app <TAB> completion for such a project (they still run when invoked explicitly).

Fixes and improvements

• snow app deploy now drops the code stage before recreating it only when the stage already exists. A first deploy has nothing to clear, so it no longer issues DROP STAGE unnecessarily, letting a role with only CREATE STAGE (and not OWNERSHIP) deploy successfully.
• Upgraded snowflake-connector-python from 4.6.0 to 4.7.1.
• Upgraded snowflake-snowpark-python from 1.41.0 to 1.53.0.

v3.22.1

Fixes and improvements

• snow streamlit deploy: fix re-deploy incorrectly attempting to UNSET schema-inherited governance tags the deploying role has no APPLY privilege on. Omitting the tags: property from snowflake.yml now leaves directly-set tags untouched; use tags: [] to explicitly clear all directly-set tags.

v3.22.0

Deprecations

New additions

• Added tags field to Streamlit entity so that tags can be set with snow streamlit deploy.
• config.toml and connections.toml files with 0644 permissions (readable by group or others) now emit a warning instead of a hard error when SF_SKIP_TOKEN_FILE_PERMISSIONS_VERIFICATION=true or SKIP_TOKEN_FILE_PERMISSIONS_VERIFICATION=true is set, aligning with snowflake-connector-python behaviour. Files writable by group or others remain a hard error regardless of the env var.

Fixes and improvements

• snow app setup now correctly preserves case-sensitive (double-quoted) identifiers in the generated snowflake.yml. Previously, values such as "lower_db" were silently stripped of their surrounding quotes by YAML, causing Snowflake to uppercase the identifier and fail to locate the object.
• snow app setup no longer writes build_compute_pool / service_compute_pool to the generated snowflake.yml, and no longer reads the DEFAULT_SNOWFLAKE_APPS_BUILD_COMPUTE_POOL / DEFAULT_SNOWFLAKE_APPS_SERVICE_COMPUTE_POOL account parameters. Snowflake App Runtime services now always run on server-managed compute pools. Existing projects that set these fields in snowflake.yml continue to be honored by snow app deploy.
• snow app setup --dry-run now exits with code 0 while still printing the same setup validation errors that a non-dry-run invocation surfaces.
• snow app deploy now supports a separate service_eai field on snowflake-app entities for newly created application services. When service_eai is not set, deploy continues to fall back to build_eai for backward compatibility.
• snow dbt deploy now preserves the customer's original key order in profiles.yml instead of silently reordering keys alphabetically.
• snow app setup and snow app deploy resolve their Snowflake App Runtime defaults via the SYSTEM$GET_APPLICATION_SERVICE_DEFAULTS() system function, and automatically fall back to the previous SHOW PARAMETERS based resolution on accounts where that function is not yet available. The fallback is transitional and will be removed once the function has fully rolled out.
• Fixed snow app events and snow app setup --dry-run crashing on Windows with an uncaught UnicodeEncodeError when their output contained non-ASCII characters (e.g. emoji, box-drawing, or accented text in application logs or the dry-run plan preview). The snow app commands now render output as UTF-8 instead of the platform default code page (cp1252/cp932 on Windows).

v3.21.0

Deprecations

New additions

• Added cli.encoding config section (and matching SNOWFLAKE_CLI_ENCODING_* env vars) to control text encoding in three areas: file_io for reading and writing project files (e.g. SQL files, snowflake.yml), subprocess for decoding output of external processes (e.g. Docker, pip), and stdout for encoding CLI output written to stdout. Setting all three to utf-8 ensures correct Unicode handling on Windows systems where the platform default encoding is not UTF-8.
• Added --no-prompt-exit-repl option and configuration setting to skip the exit confirmation prompt in the SQL REPL.
• Added --server-session-keep-alive global connection flag (plus matching SNOWFLAKE_SERVER_SESSION_KEEP_ALIVE env var and server_session_keep_alive config key) that prevents Snowflake from closing idle sessions. Useful for long-running operations or connections held open between multiple operations.

Fixes and improvements

• Fixed REST API object operations (e.g. snow object create) crashing with ModuleNotFoundError: No module named 'snowflake.connector.vendored' when running against the Snowflake Universal Driver (connector-python v5). HTTP error handling now works on both connector v4.x and the Universal Driver v5.
• The snow app setup --compute-pool option and the build_compute_pool / service_compute_pool fields of a snowflake-app entity are now hidden and undocumented (omitted from --help and the generated project-definition JSON schema). They remain fully functional: snow app setup and snow app deploy still honor the DEFAULT_SNOWFLAKE_APPS_BUILD_COMPUTE_POOL / DEFAULT_SNOWFLAKE_APPS_SERVICE_COMPUTE_POOL account parameters and any compute pools configured in snowflake.yml. The ENABLE_APPLICATION_SERVICE_MANAGED_COMPUTE_POOL and ENABLE_APPLICATION_SERVICE_MANAGED_COMPUTE_POOL_FALLBACK parameter checks (and the related deploy-time warning) have been removed.
• snow streamlit deploy --replace now uses ALTER STREAMLIT ... SET instead of CREATE OR REPLACE STREAMLIT when the app already exists, preserving existing grants and permissions on the object.
• Fixed snow app setup incorrectly treating system-default parameter values as admin-configured values. After running ALTER ACCOUNT UNSET on DEFAULT_SNOWFLAKE_APPS_BUILD_COMPUTE_POOL or DEFAULT_SNOWFLAKE_APPS_SERVICE_COMPUTE_POOL, those fields no longer appear in the generated snowflake.yml or --dry-run output.
• Upgraded pip from 26.1.1 to 26.1.2.
• snow app setup and snow app deploy now default to a workspace (instead of a stage) for app code whenever the resolved destination is a personal database (USER$<user>), which do not support stages. An explicitly configured code_stage is still honored, with a warning when the destination is a personal database.
• Fixed snow app deploy failing on Windows when uploading app code to a workspace (connector error 253006, ER_FILE_NOT_EXISTS) due to a malformed local file URI.
• Fixed snow app deploy failing with connector error 253006 when an app's files live under directories whose names contain glob metacharacters — for example Next.js dynamic-route directories such as [id] or [...slug]. The connector expands PUT sources as glob patterns, so the unescaped local path matched nothing (File doesn't exist) or a same-named sibling directory (Not a file but a directory). Local file paths are now escaped before being passed to PUT. This affected the workspace upload path used for personal-database destinations.
• snow app deploy now uploads app code to a stage one file at a time (preserving the directory structure) instead of via a recursive PUT <dir>/*, and no longer deletes the local bundle during upload. The per-file form also avoids the directory-matching glob behind connector error 253006.
• The build_eai field of a snowflake-app entity can now be specified as a bare string (e.g. build_eai: MY_EAI) in addition to the existing build_eai:\n name: MY_EAI object form.
• snow app setup now honors the --warehouse, --database, and --schema connection options as explicit overrides for the generated snowflake.yml, taking precedence over account parameters and the connection defaults. This lets users target a warehouse, database, or schema other than the account defaults. When --database is specified, --schema must also be specified.
• snow dcm commands now use the system temporary folder to bundle project files before uploading, rather than creating the output project directory and dropping it afterward
• snow dbt no longer rejects valid --dbt-version values (e.g. 2.0.0-preview.175) that don't match a hard-coded client-side regex. Versions are now validated against the server's supported list, with unsupported versions failing fast and listing the actual supported set.
• Fixed snow app commands (e.g. snow app deploy, snow app validate) failing on Windows with a UnicodeDecodeError when snowflake.yml contained non-ASCII characters (e.g. a non-Latin app title or description). The snow app command group now defaults to reading and writing snowflake.yml as UTF-8 instead of falling back to the platform default code page (cp1252/cp932 on Windows). An explicit cli.encoding.file_io setting still takes precedence when configured; UTF-8 is only the default for snow app commands. Other commands continue to honor the cli.encoding.file_io setting / platform default when reading project files.
• The --deploy-only flag of snow app deploy has been renamed to --promote-only. The previous --deploy-only name continues to work as a hidden alias for now, but this backward compatibility is temporary and will be removed soon.
• snow app deploy now drops and recreates the code stage before uploading (instead of clearing it with REMOVE) so each deploy always starts from an empty stage. This prevents stale files from a previous deploy from being mixed into the build, which could produce incorrect or conflicting build artifacts.
• snow app deploy now uploads app code files in parallel (up to 5 at a time) instead of one at a time, reducing upload time for apps with many files. This applies to both the stage and workspace upload paths.

v3.20.0

Deprecations

New additions

• Added a --protocol option (plus matching SNOWFLAKE_PROTOCOL env var and protocol config key) to snow connection add and the global connection overrides. This allows selecting http or https as the connection protocol without editing config.toml, which is primarily useful for local development against http deployments.
• Added snow helpers generate-project-schema command to emit a JSON Schema for the snowflake.yml project definition file. The output follows JSON Schema Draft 2020-12 and can be plugged into supported editors (e.g. VS Code via the YAML extension) or CI pipelines to get completion and to catch structural mistakes (unknown keys, wrong types, missing required fields) before a deploy. The schema is generated from the CLI's own models, so some cross-field and semantic checks are still only applied at load/deploy time. Use --definition-version to select the project definition version (1, 1.1, or 2; defaults to 2) and --output-file/-o to write the schema to a file.

Fixes and improvements

• Fixed TooManyFilesError during snow streamlit deploy when main_file is a descendant of a directory listed in artifacts.
• Upgraded snowflake-connector-python from 4.5.0 to 4.6.0.
• snow dcm list-deployments and snow dcm drop-deployment now wrap the project name in IDENTIFIER(...), matching every other DCM subcommand. Fully-qualified and quoted project names are now handled consistently.
• Fixed snow sql table output rendering as a series of | characters when selecting many columns into a non-terminal destination (e.g. piped or redirected output).
• get_account_identifier() and snow spcs service build-image now raise a clear, user-visible error when CURRENT_ORGANIZATION_NAME() / CURRENT_ACCOUNT_NAME() return no row or a NULL value, instead of a cryptic TypeError: 'NoneType' object is not subscriptable / AttributeError: 'NoneType' object has no attribute 'lower'.
• snow app setup and snow app deploy now verify the current role can deploy to the account-configured destination (the DEFAULT_SNOWFLAKE_APPS_DESTINATION_DATABASE / DEFAULT_SNOWFLAKE_APPS_DESTINATION_SCHEMA account defaults) before using it. When the role is missing the required privileges, the commands fall back to your personal database — as if no account default were set — and print a warning listing the missing grants and pointing you to your account administrator.

v3.19.0

Deprecations

New additions

• Added --local-only flag to snow sql. When set, !source and !load directives that reference http:// or https:// URLs are rejected instead of fetched, restricting the command to local SQL files. Useful for running SQL in environments where outbound network access from the CLI is undesirable, or when SQL inputs should be reviewed locally before execution. Local file !source/!load are unaffected. The flag also applies to the interactive REPL and to files reached transitively via nested !source.

Fixes and improvements

v3.18.0

Deprecations

New additions

• Added snow streamlit logs command to stream live logs from a Streamlit-in-Snowflake app running on the SPCSv2 container runtime. Supports --tail for historical lines, --name to target apps without a project definition, and honors the global --format flag (plain / JSON / CSV) for downstream piping.

Fixes and improvements

• Updated snowflake-connector-python to version 4.5.0.
• Updated gitpython to version 3.1.50.
• Fixed macOS arm64 installer incorrectly requiring Rosetta 2. The Distribution.xml package metadata now declares hostArchitectures="arm64,x86_64", so the installer is recognized as native on Apple Silicon.
• Fixed snow spcs service build-image on Azure accounts to work with stages using SNOWFLAKE_FULL encryption.
• Fixed SQL string literal escaping in identifier_to_show_like_pattern and to_string_literal to use Snowflake's standard single-quote doubling ('') instead of backslash escaping, which is not interpreted under the default STANDARD_ESCAPE_SEQUENCES=FALSE session setting. This closes SQL injection vectors through SHOW ... LIKE queries driven by a project-controlled snowflake.yml or manifest.yml.
• Upgraded pip to version 26.1.1.
• Fixed snow connection list crashing with AttributeError when config.toml contains a scalar value directly under [connections]. Such entries are now skipped with a warning so valid connections are still listed.
• Fixed SQL injection via FQN.sql_identifier.
• Fixed Snowsight URL generation (used by snow streamlit deploy, snow streamlit get-url, snow app run, snow notebook, and similar commands) for accounts whose host is 4-part (e.g. <account>.us-east-1.snowflakecomputing.com) or 5-part with a cloud suffix (e.g. <account>.<region>.aws.snowflakecomputing.com). These hosts now resolve to the correct regioned Snowsight URL instead of raising "host (...) was missing or not in the expected format".
• Fixed boolean connection parameters (client_store_temporary_credential, oauth_disable_pkce, oauth_enable_refresh_tokens, oauth_enable_single_use_refresh_tokens) being passed to the connector as raw strings when supplied via SNOWFLAKE_* or SNOWFLAKE_CONNECTIONS_<name>_* environment variables. Values like false / 0 are now correctly interpreted as False rather than truthy strings.
• Fixed SQL injection in snow spcs service create, execute-job, and upgrade where a $$ sequence in a YAML spec file could break out of the dollar-quoted SQL literal and execute arbitrary SQL with the caller's session privileges. $$ sequences in spec content are now neutralized before the spec is embedded in SQL.
• Improved file handling in the read_file_content and procedure_from_js_file Jinja filters used during SQL template rendering.
• Improved path handling in the Snowpark annotation processor (nativeapp codegen snowpark).
• Improved path handling for post-deploy sql_script hooks.
• Improved string handling in CREATE STREAMLIT SQL emitted by snow streamlit deploy and related commands.
• Improved output of repr(ConnectionContext) and related debug logs.
• Improved file handling in artifact bundling for snow app and snow snowpark.
• Improved input handling in snow git setup, snow connection secret creation, and API integration creation.
• Improved argument handling in SPCS service status and log commands.
• Improved input handling in snow cortex complete and snow cortex translate.
• Improved pattern handling for --like arguments to snow object show, snow git show, and snow spcs image-repository list-images.

v3.17.1

Backward incompatibility

Deprecations

New additions

Fixes and improvements

• Encrypted private key files no longer require PRIVATE_KEY_PASSPHRASE to be set in the environment. The passphrase can now be read from private_key_file_pwd (the name used by snowflake-connector-python) or private_key_passphrase in connections.toml / config.toml. The PRIVATE_KEY_PASSPHRASE environment variable continues to take precedence when set. This also fixes a regression in 3.17.0 where commands using key-pair authentication with private_key_passphrase in connections.toml failed with argument 'password': Cannot convert "<class 'str'>" instance to a buffer.

v3.17.0

Deprecations

New additions

• snow app now supports both Snowflake Native Apps (application / application package entities) and Snowflake Apps Deploy (snowflake-app entities). The entity type in snowflake.yml determines which flow is used, so shared subcommands like bundle, deploy, validate, open, events, and teardown automatically pick the correct behavior. The experimental hidden snow __app command group and the ENABLE_SNOWFLAKE_APPS feature flag have been removed.
• Added snow app setup command for initializing a snowflake.yml for a Snowflake Apps Deploy project.
• Added snow connection generate-workload-identity-token command to generate a workload identity token for the current environment. Supports AWS, GCP, Azure, and OIDC providers via --workload-identity-provider flag or connection configuration.
• Added snow custom-image validate command to validate custom Docker images against configured rules (entrypoint, environment variables, Python packages, dependency health). Supports an optional --scan-vulnerabilities flag to run Grype vulnerability scanning.
• Added snow dcm purge command to drop all the objects managed by the specified DCM Project
• DCM manifest targets now validate account_identifier and project_owner fields. CLI validates these against the current session and prints a warning on mismatch:
  • account_identifier is checked for all manifest-based commands
  • project_owner is checked for snow dcm create
• Added a --secondary-roles option (plus matching SNOWFLAKE_SECONDARY_ROLES env var and secondary_roles config key) to snow connection add and the global connection overrides. The value is forwarded to snowflake-connector-python and accepts ALL or NONE, so sessions can be pinned to the primary role without running an extra USE SECONDARY ROLES statement.
• Added --force flag to snow spcs service drop to allow dropping services that contain block storage volumes.

Fixes and improvements

• Significantly improved DCM files upload performance
• Fixed snow streamlit deploy failing with a collision error when pages/*.py glob in additional_source_files overlaps with the automatically-included pages/ directory. Overlapping glob patterns are now deduplicated during v1-to-v2 definition conversion.
• Updated snowflake-connector-python to version 4.4.0. Connector python 4.x series introduced stricter permission checks. In future versions of Snowflake CLI strict configuration file permissions will become mandatory. To test if your files have correct permissions set SNOWFLAKE_CLI_FEATURES_ENFORCE_STRICT_CONFIG_PERMISSIONS=1 before running CLI commands.
• Fixed error message when PRIVATE_KEY_PASSPHRASE environment variable is set to an empty string.
• Fixed SELECT * output being corrupted when joined tables share column names. Duplicate column names are now disambiguated by appending a numeric suffix (e.g. NAME, NAME_2).
• Fixed snow connection generate-jwt and snow connection generate-workload-identity-token failing with Connection None is not configured when used with --temporary-connection.
• The internal connection cache now remembers failed connect attempts and re-raises the original exception on subsequent accesses within the same process, instead of re-dialing Snowflake every time a command accesses the shared connection. This fixes, among other cases, the customer-visible duplicate LOGIN_HISTORY events (and OVERFLOW_FAILURE_EVENTS_ELIDED) previously emitted when a snow invocation was rejected by an authentication policy.
• Fixed session/master token connections created from environment variables or named connection config not enabling token keep-alive settings. This could cause follow-up commands to fail with 251007: Session and master tokens invalid.

v3.16.0

Deprecations

New additions

• DCM commands are now available in preview
• Added --in-account flag to list commands (e.g., snow object list, snow stage list). This flag allows listing all objects of a given type in the account. Cannot be used together with the --in flag.
• Added experimental command snow spcs service build-image to build container images using SPCS service. The command uploads local build context to a stage, executes a build job, and streams logs in real-time until completion. This command is experimental and subject to change.
• Added --async flag to snow spcs service execute-job command to execute job services asynchronously without waiting for completion.
• Added --replicas parameter to snow spcs service execute-job command to specify the number of job replicas to run.
• Added --dbt-version flag to snow dbt deploy and snow dbt execute commands. This flag allows to set dbt Core version on dbt project object (deploy command) or execute a dbt command on a specific dbt Core version, without altering the dbt object (execute commands).

Fixes and improvements

• Fixed snow stage copy --recursive dropping database and schema qualifiers from fully-qualified stage names, causing the command to resolve stages against the connection's default database instead of the one specified in the FQN.
• all authenticators (including snowflake-jwt, username_password_mfa, workload_identity) are now case-insensitive.
• Fixed snow streamlit deploy --prune failing with incorrect stage path format for streamlit entities using versioned deployment. The snow:// prefix is now correctly preserved through all stage path operations.
• Fixed a bug with snow dbt deploy where dbt project would have files uploaded first and project properties updated afterwards. This could lead to failed deploys if for example project lacked external access integrations and dependencies were specified.
• Changed how the fully qualified name for temporary stages is established for snow dbt deploy. The database and schema from the DBT Project object's fully qualified name take precedence over those from the session.
• Fixed snow stage copy and snow stage put failing when a local directory path contains glob special characters (e.g. square brackets in [id] or [slug]). The path is now escaped before glob expansion so literal directory names are matched correctly.
• Fixed Jinja block statements ({% if %}, {% for %}) containing semicolons being incorrectly split before rendering, causing TemplateSyntaxError when using --enable-templating jinja.

v3.15.0

Deprecations

New additions

• Added --if-exists option to snow object drop command and object-specific drop commands (e.g., snow stage drop) to drop objects only if they exist, preventing errors when dropping non-existent objects.

Fixes and improvements

• Fix git repository path parsing to allow quotes around both repo and branch names (e.g., @"example-repo"/branches/"feature/branch"/*).
• Fix externalbrowser auth for headless systems.
• Update project definition with supported python versions aligned with snowflake-connector-python

v3.14.0

Deprecations

• snow streamlit deploy --experimental flag is deprecated. Versioned deployment is now the default behavior.

New additions

• snow streamlit deploy now uses versioned stages by default (modern FROM syntax with automatic version management)
• Added snow streamlit deploy --legacy flag to use the legacy ROOT_LOCATION deployment for backward compatibility

Fixes and improvements

v3.13.1

Backward incompatibility

Deprecations

New additions

Fixes and improvements

• Fixed parsing of --vars provided to snow dbt execute subcommands. This allows to pass variables in the same way as to dbt cli, i.e. --vars '{"key": "value"}'

v3.13.0

Deprecations

New additions

• Added global option --decimal-precision allowing setting arbitrary precision for Python's Decimal type.
• Added support for auto_suspend_secs parameter in SPCS service commands (deploy, set, unset) to configure automatic service suspension after inactivity period.
• Added snow dbt describe and snow dbt drop commands
• Added snow dbt execute ... retry subcommand
• Added new flags to snow dbt deploy command:
  • --default-target to set a default target
  • --unset-default-target to clear default
  • --external-access-integration sets external access integrations (needed to pull external deps on altering dbt project object)
  • --install-local-deps instructs to install dependencies located in the project
• Added support for running Streamlit on SPCS runtime

Fixes and improvements

• Bumped snowflake-connector-python==3.18.0
• Grant privileges defined in snowflake.yml after deploying Streamlit
• Relaxed dbt profiles.yml validation rules; added extra validation for role specified in profiles.yml

v3.12.0

Deprecations

New additions

• The !edit command for external editors was added to REPL
• Added --partial flag to snow logs command for partial, case-insensitive object name matching

Fixes and improvements

• Fixed crashes with older x86_64 Intel CPUs
• Improved parsing !source with trailing comments
• ! commands no longer require trailing ; for evaluation
• Bumped to typer=0.17.3. Improved displaying help messages.
• Fixed using ctx.var in snow sql with Jinja templating.
• Fixed issues when pasting content with trailing new lines.
• Improved output handling with streaming
• Bumped snowflake-connector-python to 3.17.3
• Fixed snow snowpark deploy failing on duplicated packages
• Fixed snow spcs logs IndexOutOfRange error

v3.11.0

Deprecations

New additions

• Add snow connection remove command
• Added support for runtime_environment_version field in notebook entity configuration, allowing specification of runtime environment version for containerized notebooks.
• Added snow auth oidc command group for managing workload identity federation authentication:
  • snow auth oidc read-token - Reads and displays OIDC tokens from CI/CD environments
  • Supports GitHub Actions OIDC provider for passwordless authentication in CI/CD pipelines

Fixes and improvements

v3.10.1

Deprecations

New additions

Fixes and improvements

• Fixed DBT deploy command to properly handle fully qualified names
• Fixed DBT deploy command to properly handle local directories with dots in names

v3.10.0

Deprecations

• Snowpark processor in Native Apps.

New additions

• Add support for passing OAuth token via --token flag.
• Added feature to allow suppressing the new version warning message in the Snowflake CLI, configurable via a configuration file or environment variable.
• Add support for --format=CSV.
• Add --enabled-temaplating flag for snow sql command, configuring which template syntax should be used to resolve variables:
  • standard (<% ... %>), enabled by default
  • legacy (&{ ... }), enabled by default
  • jinja (new) ({{ ... }}), disabled by default
• Added packages alias for artifact_repository_packages in the snowflake.yml schema.
• Added support for copying files between named stages using snow stage copy @src_stage @dst_stage command.
• DBT commands: deploy, execute and list are now available in preview.

Fixes and improvements

• Fixed failing snow sql command when snowflake.yml is invalid and query has no templating.
• Fix JSON serialization for Decimal, time and binary.
• Added --format=JSON_EXT option to return JSON objects as proper JSON structures rather than strings.
• Refactored Streamlit app deployment (using FROM <stage> syntax); removed deprecated Streamlit features

v3.9.1

Deprecations

New additions

• Added --private-link flag to snow spcs image-registry login command to login using private link URLs.

Fixes and improvements

v3.9.0

Deprecations

New additions

• Added --encryption flag to snow stage create command defining the type of encryption for all files on the stage.

Fixes and improvements

• Fix use commands error if current database is not set.

v3.8.3

Deprecations

New additions

• Added --private-link flag to snow spcs image-registry url command for retrieving private link URLs.

Fixes and improvements

v3.8.2

Deprecations

New additions

Fixes and improvements

• Fix enable_release_channels property in application package definition to default to None instead of False.

v3.8.1

Deprecations

New additions

Fixes and improvements

• Upgrade message is printed to stderr.
• Fixed snowflake.core import issue on newer Python versions

v3.8.0

Deprecations

New additions

• Added support for OAuth tokens.
• Cleaning up the output directory after coping files to the stage for Streamlit, Notebook, SPCS Service and project.
• Added interactive mode for snow sql.
• Added support for async SQL queries (;> syntax).
• Added support for !queries, !result and !abort commands from SnowSQL.
• Added artifact_repository, artifact_repository_packages and resource_constraint fields to the Snowpark Entity Model to support direct usage of non-anaconda packages.
• Added --single-transaction flag to snow sql. Wraps BEGIN/COMMIT around statements to execute them as a single transaction, ensuring all commands complete successfully or no change is applied.

Fixes and improvements

• Fix for deploying Snowpark project using != operator in requirements.txt.
• Fix escaping identifiers for use commands.
• Move enable_release_channels from global feature flag to project level.
• Fixed snow spcs service metrics command to accept fully qualified service names.

v3.7.2

Deprecations

New additions

Fixes and improvements

• Fix error appearing on help messages after click BCR update.

v3.7.1

Deprecations

New additions

Fixes and improvements

• Fix certificate connection issues.
• Fix snow spcs image-registry login slow query problem.

v3.7.0

Deprecations

New additions

• Added --prune flag to deploy commands, which removes files that exist in the stage, but not in the local filesystem.
• Added snow logs command for retrieving and streaming logs from the server.
• Added snow helper check-snowsql-env-vars which reports environment variables from SnowSQL with replacements in CLI.

Fixes and improvements

• Updated MacOS postinstall script to update PATH if snow not exist.

v3.6.0

Deprecations

New additions

• Added support for !source command in SQL. This command allows to execute SQL from a local file.

Fixes and improvements

• Fix for incompatible options in snow spcs compute-pool commands didn't raise error.
• Change binary builds to embed whole Python environment.
• Fixed recursive copying to stage for unbalanced directory trees.
• Fixed checking for new CLI version.
• Added file execution log in stage and git commands.

v3.5.0

Deprecations

New additions

• Extended snowflake.yml support for new entities:
  • SPCS compute pool
  • SPCS service
  • SPCS image repository
• Added snow compute-pool deploy command using snowflake.yml file.
• Added snow spcs service deploy command using snowflake.yml file.
• Added snow image-repository deploy command using snowflake.yml file.
• Added support for creating native applications with manifest version 2.

Fixes and improvements

• Fix handling of date types in snow sql command when using JSON for output format

v3.4.1

Backward incompatibility

Deprecations

New additions

• Add an optional stage_subdirectory field to application package entity. When specified, application artifacts are uploaded to this subdirectory instead of the root of the application package's stage.
• Add snow spcs service events command to retrieve service-specific events:
  • Supports filtering by service name, container name, instance ID, time intervals (--since, --until), and pagination (--first, --last).
  • Use --all to fetch all columns.
• Add snow spcs service metrics command to fetch service metrics:
  • Supports filtering by service name, container name, instance ID, and time intervals (--since, --until).
  • Use --all to fetch all columns.
• Added support for glob pattern (except **) in artifact paths in snowflake.yml for Streamlit.
• Added support for glob pattern (except **) in artifact paths in snowflake.yml for Snowpark, requires ENABLE_SNOWPARK_GLOB_SUPPORT feature flag.
• Added command snow app release-directive add-accounts and snow app release-directive remove-accounts
• Added snow app release-channel set-accounts command to set accounts for release channel.
• Added support for Mac Os x86_64 architecture.
• Added --force-replace flag in snow snowpark deploy command to replace entities even if no changes are detected.
• Changes to notebook commands:
  • Added snow notebook deploy command that allows creating a notebook using local file.
  • Add support for containerized notebooks.
  • Added notebooks to snow object commands.

Fixes and improvements

• Fixed MFA caching issue in binaries.
• Fixed auto-completion issue in binaries.

v3.3.0

Backward incompatibility

Deprecations

• Added deprecation message for default Streamlit warehouse

New additions

• Add support for Release Directives by introducing the following commands:
  • snow app release-directive list
  • snow app release-directive set
  • snow app release-directive unset
• snow app version create now returns version, patch, and label in JSON format.
• Add --from-stage flag to snow app version create to allow version creation from the content of the stage without re-syncing to the stage.
• Add support for release channels:
  • Add support for release channels feature in native app version creation/drop.
  • Add ability to specify release channel when creating application instance from release directive: snow app run --from-release-directive --channel=<channel>
  • Add ability to list release channels through snow app release-channel list command
  • Add ability to add and remove accounts from release channels through snow app release-channel add-accounts and snow app release-channel remove-accounts` commands.
  • Add ability to add/remove versions to/from release channels through snow app release-channel add-version and snow app release-channel remove-version commands.
• Add publish command to make it easier to manage publishing versions to release channels and updating release directives: snow app publish
• Add support for restricting Snowflake user authentication policy to Snowflake CLI-only. For more infotmation, check the documentation.
• Added a new command: snow helpers import-snowsql-connections allowing to import configuration of connections from SnowSQL.

Fixes and improvements

• Fixed inability to add patches to lowercase quoted versions
• Fixes label being set to blank instead of None when not provided.
• Fixes generate-jwt command to preserve command line connection options.
• Fixed stage path handling for notebook commands.

v3.2.2

Backward incompatibility

Deprecations

New additions

Fixes and improvements

• Fix "No module named 'pandas'" warning.

v3.2.1

Backward incompatibility

Deprecations

New additions

Fixes and improvements

• Fixed crashes with older x86_64 Intel CPUs.

v3.2.0

Deprecations

• manifest field of application package entity is now optional. This field does not have any functionality.

New additions

• Added --retain-comments option to snow sql command to allow passing comments to Snowflake.
• Added --replace and --if-not-exists options to snow object create command.
• Added support for event sharing, which now can be specified under the telemetry section of an application entity. Two fields are supported: share_mandatory_events and optional_shared_events.
• snow stage copy supports --recursive flag to copy local files and subdirectories recursively to stage. Including glob support.
• snow helpers v1-to-v2 now converts v1 template references to v2 in Native App artifacts that use the templates processor.
• Added --label option to snow app version create command to allow adding labels to versions and patches.
• Enhanced snow spcs service logs command with new parameters for improved log retrieval and monitoring.
  • --previous-logs: Retrieve logs from the last terminated container.
  • --since: Start log retrieval from a specified UTC timestamp.
  • --include-timestamps: Include timestamps in log entries for log streaming.
  • --follow: Stream logs in real-time.
  • --follow-interval: Set custom polling intervals during log streaming.
• snow connection add supports --no-interactive flag to skip interactive prompts.

Fixes and improvements

• snow --info callback returns information about SNOWFLAKE_HOME variable.
• Removed requirement of existence of any requirements.txt file for Python code execution via snow git execute command. Before the fix the file (even empty) was required to make the execution working.
• Fixed saving of the config file updates when connections.toml exists. Removed incorrect copying of connections from connections.toml to config.toml.
• Fixes snow connection generate-jwt to work with keys with no passphrase.
• The privilege to create a schema or stage is no longer required to run snow app version create if the schema and stage already exist.
• Fix Windows permissions error on files created by CLI when owner is a part of custom group with granted default permissions.

v3.1.0

Deprecations

• Added deprecation warning in the description of snow spcs service status and snow spcs image-repository list-tags.
• Completely removed the snow app init as it was replaced with snow init in Snowflake CLI 3.0

New additions

• Added snow connection generate-jwt command to generate JWT token for Snowflake connection.
• Added snow spcs service list-instances, snow spcs service list-containers and snow spcs service list-roles commands, which support fetching information about all instances/containers/service roles in a service.
• snow spcs service set now supports --eai-name to update external access integrations for a service.

Fixes and improvements

• Fixed a bug that would cause the deploy_root, bundle_root, and generated_root directories to be created in the current working directory instead of the project root when invoking commands with the --project flag from a different directory.
• Align variables for snow stage|git execute. For Python files variables are stripped of leading and trailing quotes.
• snow spcs service list-images now displays image tag and digest.
• Fix snow stage list-files for paths with directories.
• Fix for list fields in mixins applied twice

v3.0.2

Backward incompatibility

Deprecations

New additions

Fixes and improvements

• Fixed the handling empty default values for strings by snow snowpark deploy.
• Added log error details if the pip command fails.
• Fix snow git execute support for Python files.

v3.0.1

Backward incompatibility

Deprecations

• Changing package name from snowflake-cli-labs to snowflake-cli. Snowflake-cli-labs will be pointing to the corresponding version of snowflake-cli.

New additions

Fixes and improvements

v3.0.0

Backward incompatibility

• Dropped support for Python below 3.10 version.
• snow object stage commands are removed in favour of snow stage.
• snow snowpark init, snow streamlit init, and snow app init commands are removed in favor of snow init command.
• Removed deprecated flags from snow snowpark commands.
• Default Python version for Snowpark functions and procedures was bumped to 3.10 from 3.8.
• Snowpark commands
  • snow snowpark build creates a .zip file for each specified artifact that is a directory. Non-Anaconda dependencies are packaged once as dependencies.zip.
  • snow snowpark deploy uploads all artifacts created during build step. Dependencies zip is upload once to every Snowpark stage specified in project definition.
  • The changes are compatible with V1 projects definition though the result state (file layout) is different.
  • snow snowpark package commands no longer fallback to Anaconda Channel metadata when fetching available packages info fails.
  • Added snow streamlit execute app-name command to run Streamlit apps in a Snowflake environment in headless mode.

Deprecations

• Renamed private-key-path flag to private-key-file, added private-key-path as an alias for backward compatibility.

New additions

• Added snow spcs service execute-job command, which supports creating and executing a job service in the current schema.
• Added snow app events command to fetch logs and traces from local and customer app installations.
• Added support for external access (api integrations and secrets) in Streamlit.
• Added support for <% ... %> syntax in SQL templating.
• Support multiple Streamlit application in single snowflake.yml project definition file.
• Added snow helpers v1-to-v2 command to migrate snowflake.yml file from V1 to V2.
• Added --package-entity-id and --app-entity-id options to snow app commands to allow targeting specific entities when the definition_version in snowflake.yml is 2 or higher and it contains multiple application package or application entities.
• Added templates expansion of arbitrary files for Native Apps through templates processor.
• Added SNOWFLAKE_..._PRIVATE_KEY_RAW environment variable to pass private key as a raw string.
• Added periodic check for newest version of Snowflake CLI. When new version is available, user will be notified.
• Added support for imports in Streamlit definition.
• Add --host and --port to connection flags.

Fixes and improvements

• Fixed problem with whitespaces in snow connection add command.
• Added check for the correctness of token file and private key paths when addind a connection.
• Fix the typo in spcs service name argument description. It is the identifier of the service instead of the service pool.
• Fix error handling and improve messaging when no artifacts provided.
• Improved error message for incompatible parameters.
• Fixed SQL error when running snow app version create and snow app version drop with a version name that isn't a valid Snowflake unquoted identifier
• Duplicated keys in snowflake.yml are now detected and reported.
• snow streamlit deploy will check for existing streamlit instance before deploying anything.
• Fixed snow git execute with / in name of the branch.
• snow app commands don't enforce ownership of the objects they manage, and rely on RBAC instead.
• snow app deploy for package entity now allows operating on application packages created outside the CLI
• Fixes snow connection add behavior when connections.toml file exists.
• Add more readable error messages in snow object create command.

v2.8.2

Backward incompatibility

Deprecations

• Changing package name from snowflake-cli-labs to snowflake-cli. Snowflake-cli-labs will be pointing to the corresponding version of snowflake-cli.

New additions

Fixes and improvements

v2.8.1

Backward incompatibility

Deprecations

New additions

Fixes and improvements

• Fixed git execute not working with upper case in directory name.
• Fixed snow git setup command behaviour for fully qualified repository names.
• Fixed snow git setup command behaviour in case API integration or secret with default name already exists.
• Fixed snow snowpark package create creating empty zip when package name contained capital letters.

v2.8.0

Backward incompatibility

Deprecations

• Added deprecation warning for native_app.package.scripts in project definition file.

New additions

• Added support for project definition file defaults in templates.
• Added support for native_app.package.post_deploy scripts in project definition file.
  • These scripts will execute whenever a Native App Package is created or updated.
  • Currently only supports SQL scripts: post_deploy: [{sql_script: script.sql}].

Fixes and improvements

• Fix return values of snow snowpark list, describe and drop commands.
• Show warnings returned by Snowflake when snow app run is successful.

v2.7.0

Backward incompatibility

Deprecations

• snow snowpark init and snow streamlit init are marked as deprecated. The commands are still functional, but should be replaced with snow init

New additions

• Added connection option --token-file-path allowing passing OAuth token using a file. The function is also supported by setting token_file_path in connection definition.
• Support for Python remote execution via snow stage execute and snow git execute similar to existing EXECUTE IMMEDIATE support.
• Added support for autocomplete in --connection flag.
• Added snow init command, which supports initializing projects with external templates.

Fixes and improvements

• The snow app run command now allows upgrading to unversioned mode from a versioned or release mode application installation
• The snow app teardown command now allows dropping a package with versions when the --force flag is provided
• The snow app version create command now allows operating on application packages created outside the CLI
• Added support for user stages in stage execute and copy commands
• Improved support for quoted identifiers in snowpark commands.
• Updated post_deploy SQL script default database to be the application database
• Handle NULL md5 values correctly when returned by stage storage backends
• Regionless host URLs are now supported when generating Snowsight URLs
• snow app run and snow app deploy now correctly determine modified status for large files uploaded to AWS S3

v2.6.1

Backward incompatibility

Deprecations

New additions

Fixes and improvements

• snow object create message returns meaningful error if connection database is not defined.
• Fixed crashing when save_logs is false and log directory does not exist

v2.6.0

Backward incompatibility

Deprecations

New additions

• Add snow object create command
• Added support for title field in Streamlit definition in snowflake.yml project file.
• Added --auto-compress flag to snow stage copy command enabling use of gzip to compress files during upload.
• Added new native_app.application.post_deploy section to snowflake.yml schema to execute actions after the application has been deployed via snow app run.
  • Added the sql_script hook type to run SQL scripts with template support.
• Added support for --env command line arguments for templating.
  • Available for commands that make use of the project definition file.
  • Format of the argument: --env key1=value1 --env key2=value2.
  • Overrides env variables values when used in templating.
  • Can be referenced in templating through ctx.env.<key_name>.
  • Templating will read env vars in this order of priority (highest priority to lowest priority):
    • vars from --env command line argument.
    • vars from shell environment variables.
    • vars from env section of project definition file.

Fixes and improvements

• Passing a directory to snow app deploy will now deploy any contained file or subfolder specified in the application's artifact rules
• Fixes markup escaping errors in snow sql that may occur when users use unintentionally markup-like escape tags.
• Fixed case where snow app teardown could not tear down orphan applications (those that have had their package dropped)
• Fixed case where snow app teardown could leave behind orphan applications if they were not created by the Snowflake CLI
• Fixed case where snow app run could fail to run an existing application whose package was dropped by prompting to drop and recreate the application
• Improve terminal output sanitization to avoid ASCII escape codes.
• The snow sql command will show query text before executing it.
• Improved stage diff output in snow app commands
• Hid the diff from snow app validate output since it was redundant
• Added log into the file with loaded external plugins
• Warn users if they attempt to use templating with project definition version 1
• Improved output and format of Pydantic validation errors
• Improved support for quoted identifiers in streamlit commands.
• The snow app run command will no longer override debug mode during an application upgrade unless explicitly set in snowflake.yml

v2.5.0

Backward incompatibility

Deprecations

New additions

• Added snow app bundle command that prepares a local folder in the project directory with artifacts to be uploaded to a stage as part of creating a Snowflake Native App.
  • Snowflake Native App projects can now optionally generate CREATE FUNCTION or CREATE PROCEDURE declarations in setup scripts from Snowpark python code that includes decorators (e.g. @sproc, @udf).
• Added snow app validate command that validates the setup script SQL used to create a Snowflake Native App for syntax validity, invalid object references, and best practices
  • Added new native_app.scratch_stage field to snowflake.yml schema to allow customizing the stage that the CLI uses to run the validation
• Changed snow app deploy and snow app run to trigger validation of the uploaded setup script SQL and block uploads on validation failure, pass --no-validate to disable
• Changed snow app version create --patch to require an integer patch number, aligning with what Snowflake expects
• Added snow notebook commands:
  • snow notebook execute enabling head-less execution of a notebook.
  • snow notebook create proving an option to create a Snowflake Notebook from a file on stage.
• Added templating support for project definition file.
  • Template variables can now be used anywhere in the project definition file.
• Added --default flag to snow connection add commands allowing users to mark the new connection as default.

Fixes and improvements

• Fixed error handling for malformatted config.toml
• Fixed ZIP packaging of Snowpark project dependencies containing implicit namespace packages like snowflake.
• Deploying function/procedure with --replace flag now copies all grants
• Fixed MFA caching
• Fixed DeprerationWarning/SyntaxWarning due to invalid escape sequences
• Improved error message in snow spcs image-registry login when docker is not installed.
• Improved detection of conflicts between artifact rules for native application projects
• Fixed URL generation for applications, streamlits, and notebooks that use a quoted identifier with spaces.

v2.4.0

Backward incompatibility

Deprecations

New additions

• Added the --cascade option to snow app teardown command that drops all application objects owned by the application.
• Add external access integration to snow object commands
• Add aliases for snow object list/describe/drop commands under:
  • snow stage for stages
  • snow git for git repository stages
  • snow streamlit for streamlit apps
  • snow snowpark for procedures and functions
  • snow spcs compute-pool for compute pools
  • snow spcs image-repository for image repositories
  • snow spcs service for services
• snow sql works now with snowflake.yml file. The variables defined in the new env section of snowflake.yml will be used to expand templates.
• snow sql support executing multiple files. Users can use -f/--file flag more than once to execute queries from many files.
• snow git execute and snow stage execute support passing input variables for SQL execution.
• Added snow cortex commands:
  • complete - Given a prompt, the command generates a response using your choice of language model. In the simplest use case, the prompt is a single string. You may also provide a JSON file with conversation history including multiple prompts and responses for interactive chat-style usage.
  • extract-answer - Extracts an answer to a given question from a text document. The document may be a plain-English document or a string representation of a semi-structured (JSON) data object.
  • sentiment - Returns sentiment as a score between -1 to 1 (with -1 being the most negative and 1 the most positive, with values around 0 neutral) for the given English-language input text.
  • summarize - Summarizes the given English-language input text.
  • translate - Translates text from the indicated or detected source language to a target language.
  • search - for integration with Cortex Search Service
• When invoked without command help is displayed by default with list of available commands.
• Add tab-completion for snow command.

Fixes and improvements

• Improved support for quoted identifiers.
• Fixed creating patches with snow app version create when there are 2 or more existing patches on a version
• Using --format=json adds trailing new line to avoid % being added by some terminals to signal no new line at the end of output.
• Fixed --interactive flag to be enabled by default in interactive environments and added the --no-interactive flag to be able to turn off prompting.

v2.3.1

Backward incompatibility

Deprecations

New additions

Fixes and improvements

• Fixed bugs in source artifact mapping logic for native applications

v2.3.0

Backward incompatibility

Deprecations

New additions

• New snow sql functionality:
  • -D/--variable allows variable substitutions in a SQL input (client-side query templating)
• New snow app deploy functionality:
  • Passing files and directories as arguments syncs these only: snow app deploy some-file some-dir.
  • --recursive syncs all files and subdirectories recursively.
  • --prune deletes specified files from the stage if they don't exist locally.

Fixes and improvements

• More human-friendly errors in case of corrupted config.toml file.
• Fixed a bug in snow app that caused files to be re-uploaded unnecessarily.
• Optimize snowpark dependency search to lower the size of .zip artifacts and the number of anaconda dependencies for snowpark projects.
• Added support for fully qualified stage names in stage and git execute commands.
• Fixed a bug where snow app run was not upgrading the application when the local state and remote stage are identical (for example immediately after snow app deploy).
• Fixed handling of stage path separators on Windows
• Change to external_access_integrations in snowflake.yml now also triggers function replace
• The --info callback returns info about configured feature flags.

v2.2.0

Backward incompatibility

Deprecations

• snow snowpark package lookup no longer performs check against PyPi. Using --pypi-download or --yes has no effect and will cause a warning. In this way the command has single responsibility - check if package is available in Snowflake Anaconda channel.
• snow snowpark package create:
  • --pypi-download or --yes flags are deprecated, have no effect and will cause a warning. create command always checks against PyPi.
  • --allow-native-libraries is deprecated in favour of boolean flag --allow-shared-libraries. Using old flag will cause a warning.
• snow snowpark build:
  • --pypi-download flag is deprecated, have no effect and will cause a warning. Build command always check against PyPi.
  • --check-anaconda-for-pypi-depts is deprecated and using it will cause warning, the functionality is replaced by --ignore-anaconda
  • --package-native-libraries is deprecated and using it will cause warning, the functionality is replaced by --allow-shared-libraries
• snow object stage commands are deprecated and using them will cause a warning. Functionality is replaced by snow stage commands.

New additions

• Added support for fully qualified name (database.schema.name) in name parameter in streamlit project definition
• Added support for fully qualified image repository names in spcs image-repository commands.
• Added --if-not-exists option to create commands for service, and compute-pool. Added --replace and --if-not-exists options for image-repository create.
• Added support for python connector diagnostic report.
• Added snow app deploy command that creates an application package and syncs the local changes to the stage without creating or updating the application.
• Added is_default column to snow connection list output to highlight default connection.
• snow snowpark package create:
  • new --ignore-anaconda flag disables package lookup in Snowflake Anaconda channel. All dependencies will be downloaded from PyPi.
  • new --skip-version-check skips comparing versions of dependencies between requirements and Anaconda.
  • new --index-url flag sets up Base URL of the Python Package Index to use for package lookup.
• snow snowpark build:
  • new --skip-version-check skips comparing versions of dependencies between requirements and Anaconda.
  • new --index-url flag sets up Base URL of the Python Package Index to use for package lookup.
• Added --recursive flag for copy from stage, it will reproduce the directory structure locally.
• Added support for snowgit. New commands:
  • snow git setup - wizard setting up a git repository stage and creating all necessary objects
  • snow git fetch - fetches latest changes from the origin repository into Snowflake repository
  • snow git list-branches - lists all branches in the repository
  • snow git list-tags - lists all tags in the repository
  • snow git list-files - lists all files on provided branch/tag/commit
  • snow git copy - copies files from provided branch/tag/commit into stage or local directory
  • snow git execute - execute immediate files from repository
• Added command for execute immediate snow object stage execute
• Fetching available packages list from Snowflake instead of directly from Anaconda with fallback to the old method (for backward compatibility). As the new method requires a connection to Snowflake, it adds connection options to the following commands:
  • snow snowpark build
  • snow snowpark package lookup
  • snow snowpark package create

Fixes and improvements

• Adding --image-name option for image name argument in spcs image-repository list-tags for consistency with other commands.
• Fixed errors during spcs image-registry login not being formatted correctly.
• Project definition no longer accept extra fields. Any extra field will cause an error.
• Changing imports in function/procedure section in snowflake.yml will cause the definition update on replace
• Adding --pattern flag to stage list-files command for filtering out results with regex.
• Fixed snowpark build paths for builds with --project option (fixed empty zip issue).
• More clear error messages in snow snowpark build command
• Adding support for any source supported by pip in snow snowpark.
• Fixed version parsing for packages lookup on Snowflake Anaconda Channel
• Fix handling database/schema/role identifiers containing dashes
• Fix schema override bug in snow connection test
• Hidden incorrectly working config permissions warning on Windows
• Make errors from snow connection test more meaningful when role, warehouse or database does not exist.

v2.1.2

Fixes and improvements

• Add pip as Snowflake-cli dependency
• Optimize connection test command
• Fix venv creation issues in snowpark package create and snowpark build command

v2.1.1

Fixes and improvements

• Improved security of printing connection details in snow connection list.
• Improved parsing of non-quoted scalar values within square brackets in manifest.yml in Native App projects.

v2.1.0

Backward incompatibility

New additions

• Added ability to specify scope of the object list command with the --in <scope_type> <scope_name> option.

• Introduced snowflake.cli.api.console.cli_console object with helper methods for intermediate output.

• Added new --mfa-passcode flag to support MFA.

• Added possibility to specify database and schema in snowflake.yml for snowpark objects. Also name can specify a fully qualify name.

• New commands for spcs

  • Added image-registry url command to get the URL for your account image registry.
  • Added image-registry login command to fetch authentication token and log in to image registry in one command.
  • Added image-repository url <repo_name> command to get the URL for specified image repository.
  • Added create command for image-repository.
  • Added status, set (property), unset (property), suspend and resume commands for compute-pool.
  • Added set (property), unset (property),upgrade and list-endpoints commands for service.

• You can now use github repo link in snow snowpark package create to prepare your code for upload

• Added allow-native-libraries option to snow snowpark package create command

• Added alias --install-from-pip for -y option in snow snowpark package create command

• Connections parameters are also supported by generic environment variables:

  • SNOWFLAKE_ACCOUNT
  • SNOWFLAKE_USER
  • SNOWFLAKE_PASSWORD
  • SNOWFLAKE_DATABASE
  • SNOWFLAKE_SCHEMA
  • SNOWFLAKE_ROLE
  • SNOWFLAKE_WAREHOUSE
  • SNOWFLAKE_MFA_PASSCODE

• Introduced --pypi-download flag for snow snowpark package commands to replace -y and --yes

  The SNOWFLAKE_CONNECTION_<NAME>_<KEY> variable takes precedence before the generic flag. For example if SNOWFLAKE_PASSWORD and SNOWFLAKE_CONNECTIONS_FOO_PASSWORD are present and user tries to use connection "foo" then the later variable will be used.

• Testing connection using snow connection test validates also access to database, schema, role and warehouse specified in the connection details.

• Added snow connection set-default command for changing default connection.

Fixes and improvements

• Restricted permissions of automatically created files
• Fixed bug where spcs service create would not throw error if service with specified name already exists.
• Improved package lookup, to avoid unnecessary uploads
• Logging into the file by default (INFO level)
• Added validation that service, compute pool, and image repository names are unqualified identifiers.
• spcs service commands now accept qualified names.
• Updated help messages for spcs commands.

v2.0.0

Backward incompatibility

• Introduced snow object group with list, describe and drop commands which replaces corresponding functionalities of procedure/function/streamlit specific commands.

• snow stage is now snow object stage

• snow stage get and snow stage put are replaced by snow object stage copy [FROM] [TO]

• snow warehouse status is now snow object list warehouse

• snow connection test now outputs all connection details (except for the password), along with connection status

• snow sql requires explicit -i flag to read input from stdin: cat my.sql | snow sql -i

• Switched to Python Connector default connection https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-connect#setting-a-default-connection

  • Default connection name changed from dev to default
  • Environment variable for default connection name changed from SNOWFLAKE_OPTIONS_DEFAULT_CONNECTION to SNOWFLAKE_DEFAULT_CONNECTION_NAME

• Snowpark changes

  • Removed procedure and function subgroups.
  • Removed snow snowpark function package and snow snowpark procedure package in favour of snow snowpark build.
  • Removed snow snowpark function create and snow snowpark function update. Functions can be deployed using snow snowpark deploy.
  • Removed snow snowpark procedure create and snow snowpark procedure update. Procedures can be deployed using snow snowpark deploy.
  • Procedures and functions use single zip artifact for all functions and procedures in project.
  • Changed path to coverage reports on stage, previously created procedures with coverage will not work, have to be recreated.
  • Previously created procedures or functions won't work with deploy command due to change in stage path of artifact. Previous code will remain under old path on stage.
  • Package commands are now under snow snowpark package.
  • Coverage commands were removed. To measure coverage of your procedures or functions use coverage locally.

• Snowpark Containers services commands

  • cp alias for compute-pool commands was removed.
  • services commands were renamed to service
  • registry commands were renamed to image-registry
  • compute-pool, service, and image-registry commands were moved from snowpark group to a new spcs group.
  • snow spcs compute-pool create and snow spcs service create have been updated with new options to match SQL interface.
  • Added new image-repository command group under spcs. Moved list-images and list-tags from image-registry to image-repository.
  • Removed snow snowpark jobs command.
  • list-images and list-tags now outputs image names with a slash at the beginning (e.g. /db/schema/repo/image). Image name input to list-tags requires new format.
  • snow spcs compute-pool stop has been removed in favor of snow spcs compute-pool stop-all.

• Streamlit changes

  • snow streamlit deploy is requiring snowflake.yml project file with a Streamlit definition.
  • snow streamlit describe is now snow object describe streamlit
  • snow streamlit list is now snow object list streamlit
  • snow streamlit drop is now snow object drop streamlit

New additions

• Added snow streamlit get-url [NAME] command that returns url to a Streamlit app.
• --temporary-connection flag, that allows you to connect, without anything declared in config file
• Added project definition for Streamlit
• Added snow streamlit get-url [NAME] command that returns url to a Streamlit app.
• Added project definition for Snowpark procedures and functions.
  • The snowflake.yml file is required to deploy functions or procedures.
  • Introduced new deploy command for project with procedures and functions.
  • Introduced new build command for project with procedure and functions
• Added support for external access integration for functions and procedures
• Added support for runtime version in snowpark procedures ad functions.
• You can include previously uploaded packages in your functions, by listing them under imports in snowflake.yml
• Added more options to snow connection add - now you can also specify authenticator and path to private key
• Added support for native applications by introducing new commands.
  • snow app init command that creates a new Native App project from a git repository as a template.
  • snow app version create command that creates or upgrades an application package and creates a version or patch for that package.
  • snow app version drop command that drops a version associated with an application package.
  • snow app version list command that lists all versions associated with an application package.
  • snow app run command that creates or upgrades an application in development mode or through release directives.
  • snow app open command that opens the application inside of your browser on Snowsight, once it has been installed in your account.
  • snow app teardown command that attempts to drop both the application and package as defined in the project definition file.
• Snowpark: add default field to procedure and function arguments definition in snowflake.yml to support named and optional arguments

Fixes and improvements

• Allow the use of quoted identifiers in stages

v1.2.5

Fixes and improvements

• Import git module only when is needed

v1.2.4

Fixes and improvements

• Fixed look up for all folders in downloaded package.

v1.2.3

Fixes and improvements

• Removed hardcoded values of instance families for snow snowpark pool create command.

v1.2.2

Fixes and improvements

• Fixed parsing of commands and arguments lists in specifications of snowpark services and jobs

v1.2.1

Fixes and improvements

• Fix homebrew installation

v1.2.0

Backward incompatibility

• Removed snow streamlit create command. Streamlit can be deployed using snow streamlit deploy
• Removed short option names in compute pool commands:
  • -n for --name, name of compute pool
  • -d for --num, number of pool's instances
  • -f for --family, instance family
• Renamed long options in Snowpark services commands:
  • --compute_pool is now --compute-pool
  • --num_instances is now --num-instances
  • --container_name is now --container-name

New additions

• snow streamlit init command that creates a new streamlit project.
• snow streamlit deploy support pages and environment.yml files.
• Support for private key authentication

Fixes and improvements

• Adjust streamlit commands to PuPr syntax
• Fix URL to streamlit dashboards

v1.1.1

Backward incompatibility

• Removed short version -p of --password option.

New additions

• Added commands:
  • snow snowpark registry list-images
  • snow snowpark registry list-tags

Fixes and improvements

• Too long texts in table cells are now wrapped instead of cropped
• Split global options into separate section in help
• Avoiding unnecessary replace in function/procedure update
• Added global options to all commands
• Updated help messages
• Fixed problem with Windows shortened paths
• If only one connection is configured, will be used as default
• Fixed registry token connection issues
• Fixes in commands belonging to snow snowpark compute-pool and snow snowpark services groups
• Removed duplicated short option names in a few commands by:
  • Removing -p short option for --password option for all commands (backward incompatibility affecting all the commands using a connection) (it was conflicting with various options in a few commands)
  • Removing -a short option for --replace-always in snow snowpark function update command (it was conflicting with short version of --check-anaconda-for-pypi-deps)
  • Removing -c short option for --compute-pool in snow snowpark jobs create (it was conflicting with short version of global --connection option)
  • Removing -c short option for --container-name in snow snowpark jobs logs (it was conflicting with short version of global --connection option)
• Fixed parsing of specs yaml in snow snowpark services create command