Snowflake CLI release notes for 2025¶

Added the !edit command to the snow sql command to support external editors.

Added the --partial option to the snow logs command to support partial, case-insensitive matching of log messages.

Improved parsing !source with trailing comments.

Upgraded to typer=0.17.3 to improve the display of help messages.

Improved output handling with streaming queries in the snow sql command.

Fixed crashes with older x86_64 Intel CPUs.

Fixed the ! commands in snow sql commands so they no longer require a trailing ; for evaluation.

Fixed using ctx.var in snow sql with Jinja templating.

Fixed issues when pasting content with trailing new lines.

Fixed an issue with snow snowpark deploy failing on duplicated packages.

Fixed an issue causing a snow spcs logs IndexOutOfRange error.

None.

None

Fixed snow dbt deploy command to properly handle fully qualified names.

Fixed snow dbt deploy command to properly handle local directories with dots in names.

This version deprecates the Snowpark processor in the Snowflake Native App Framework.

Added support for passing an OAuth token with the --token option.

Added the ability to suppress new Snowflake CLI version messages.

Added the following new --format options for outputting data:

• CSV, which formats query output as CSV.

• JSON_EXT, which outputs JSON as JSON objects instead of strings.

Added the --enabled_templating option for the snow sql command that lets you specify which of the following templates to use when resolving variables:

• Standard (<% ... %>), enabled by default.

• Legacy (&{ ... }), enabled by default.

• Jinja ({{ ... }}), disabled by default.

Added a packages alias for artifact_repository_packages in the snowflake.yml schema.

Added the snow stage copy @src_stage @dst_stage command for copying files directly between two named stages.

Added support for the DBT deploy, execute, and list commands.

Fixed an issue where the snow sql command would fail when snowflake.yml is invalid and the query has no templating.

Fixed an issue with JSON serialzation for the Decimal, time, and binary data types.

Added the --private-link option to snow spcs image-registry login command to log in using private link URLs.

None.

Added the --encryption option to the snow stage create command to define the type of encryption to use for all files on the stage.

Fixed errors that occurred for use commands if the current database is not set.

None

Added the --private-link option to the snow spcs image-registry url command for retrieving private link URLs.

None

Changed the enable_release_channels property default from False to None.

None

The upgrade message is now sent to stderr.

Fixed a snowflake.core import issue on newer Python versions.

Added support for OAuth tokens.

Added the following enhancements to the snow sql command:

• Added an interactive mode.

• Added support for asynchronous SQL queries.

• Added support for the !queries, !result, and !abort SQL query commands.

• Added the --single-transaction command line option to execute multiple SQL queries as an all-or-nothing batch, ensuring that all commands complete successfully before any of the changes are committed.

• Added the artifact_repository field to the Snowpark Entity Model to support using non-anaconda packages.

Fixed an issue with deploying Snowpark project using the != operator in requirements.txt.

Fixed an issue with escaping identifiers for use commands.

Moved the enable_release_channels parameter from the global level to the project level.

Fixed the snow spcs service metrics command to accept fully qualified service names.

None.

Fixed an issue with errors appearing in help messages.

None.

Fixed certificate connection issues.

Fixed a snow spcs image-registry login slow query problem.

Added the --prune option to the snow notebook deploy, snow snowpark deploy, and snow streamlit deploy commands that removes files that exist in the stage, but not in the local filesystem.

Added the snow logs command for retrieving and streaming logs from the server.

Added the snow helper check-snowsql-env-vars that reports environment variables from SnowSQL with their Snowflake CLI replacements.

Updated the MacOS post-install script to update the PATH environment variable, if needed, to ensure the snow command is available.

Added support for the !source command in SQL queries to allow executing SQL from local files.

Fixed an issue with incompatible options in snow spcs compute-pool commands that didn’t raise error.

Changed binary builds to embed the whole Python environment.

Fixed recursive copying to a stage for unbalanced directory trees.

Fixed checking for a new Snowflake CLI version.

Added file execution logs in snow stage and snow git commands.

Extended project definition (snowflake.yml) support for the following SPCS (Snowpark Container Services) entities:

• Compute pool

• Image repository

• Service

Added the snow spcs compute pool deploy command that reads a snowflake.yml project definition file.

Added the snow spcs image repository deploy command that reads a snowflake.yml project definition file.

Added the snow spcs service deploy command that reads a snowflake.yml project definition file.

Fixed an issue with data type handling in the snow sql command when using JSON for the output format.

Fixed an MFA caching issue in the Snowflake CLI binary installation files.

Fixed an auto-completion issue in the Snowflake CLI binary installation files.

Added the following Snowflake Native Apps features and updates:

• Added the following commands to support release directives:

  • snow app release-directive list

  • snow app release-directive set

  • snow app release-directive unset

• Added support for release channels, including the following:

  • Added support release channels in the snow app version create and snow app version drop commands.

  • Added the ability to specify a release channel when creating an application instance from a release directive (snow app run --from-release-directive --channel=<channel>).

  • Added the snow app release-channel list to list available release channels.

  • Added the now app release-channel add-accounts and snow app release-channel remove-accounts commands to support adding and removing accounts from release channels.

  • Added the snow app release-channel add-version and snow app release-channel remove-version commands to add versions to and remove versions from release channels.

• Added the snow app publish command to simplify publishing versions to release channels and to update release directives.

• Made the following changes to the snow app version create command:

  • The command now returns the version, patch, and label in JSON format.

  • Added the --from-stage option to allow version creation from the content of a stage without needing to re-synchronize to the stage.

Added the snow helpers import-snowsql-connections command to import connections from existing SnowSQL configurations.

Added support for restricting user access to Snowflake CLI only. For more information, see Add an authentication policy that limits access to Snowflake CLI only.

Fixed the inability to add patches to lowercase quoted versions.

Fixed an issue with setting label to blank instead of None when not provided.

Fixed the snow connection generate-jwt command to preserve command line connection options.

Fixed stage path handling for notebook commands.