A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://docs.snowflake.com/en/sql-reference/sql/alter-application-package-version below:

ALTER APPLICATION PACKAGE … VERSION

Reference SQL command reference Native Apps Framework ALTER APPLICATION PACKAGE ALTER APPLICATION PACKAGE ... VERSION ALTER APPLICATION PACKAGE … VERSION

Modifies the versioning of an existing application package in the Snowflake Native App Framework.

See also:

ALTER APPLICATION PACKAGE , ALTER APPLICATION PACKAGE … RELEASE DIRECTIVE

Syntax
ALTER APPLICATION PACKAGE <name> ADD VERSION [ <version_identifier> ]
  USING <path_to_version_directory> [ LABEL = '<display_label>' ]

ALTER APPLICATION PACKAGE <name> DROP VERSION <version_identifier>

ALTER APPLICATION PACKAGE <name> ADD PATCH [<patch_number>] FOR VERSION [<version_identifier>]
  USING <path_to_version_directory> [ LABEL = '<display_label>' ]

Copy

Parameters
name

Specifies the identifier for the application package to alter. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

ADD VERSION [ version_identifier ] USING path_to_version_directory

Adds a version or patch using the application files located in the path to a stage location specified by path_to_version_directory.

You can specify an identifier for this version using version_identifier. If you do not specify a version_identifier in the manifest file, you must specify a version_identifier as part of this command. If you specify version_identifier as part of this command, it takes precedence over version_identifier specified in the manifest file.

[ LABEL = 'display_label' ]

You can use the LABEL clause to specify a label for this new version. This label is displayed to the consumer. If you omit the LABEL clause, the label specified in the manifest.yml file is used.

DROP VERSION version_identifier

Drops the version with the specified version name.

Drops a version with the specified version identifier. A version may only be dropped when there are no release directives that are referring to it. Dropping is an asynchronous process and completes when all application instances have successfully upgraded from the older version and no longer have code running on the dropping version.

Use the APPLICATION_STATE view view to monitor the state of the application instances. Use the SHOW VERSIONS IN APPLICATION PACKAGE command to monitor the status of the dropped version.

ADD PATCH patch_number FOR VERSION version_identifier . USING path_to_version_directory [ LABEL = 'display_label' ]

Adds a patch for the specified version (version_identifier) using the application files located in the specified path to a stage location (path_to_version_directory).

You can use the LABEL clause to specify a label for this new patch. This label is displayed to the consumer. If you omit the LABEL clause, the label specified in the manifest.yml file is used.

Usage notes Examples
ALTER APPLICATION PACKAGE hello_snowflake_package
  ADD VERSION v1_1
  USING '@hello_snowflake_code.core.hello_snowflake_stage';

Copy

+---------------------------------------------------------------------------------------+---------+-------+
| status                                                                                | version | patch |
|---------------------------------------------------------------------------------------+---------+-------|
| Version 'v1_1' of application package 'hello_snowflake_package' created successfully. | v1_1    |     0 |
+---------------------------------------------------------------------------------------+---------+-------+

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4