Lists the release directives defined for an application package in the Native Apps Framework.
The output returns metadata and properties for the release directives in an application package, ordered lexicographically by name. This is important to note if you want to filter the results using the provided filters.
ALTER APPLICATION PACKAGE, CREATE APPLICATION PACKAGE, DROP APPLICATION PACKAGE, SHOW APPLICATION PACKAGES
SHOW RELEASE DIRECTIVES [ LIKE '<pattern>' ] IN APPLICATION PACKAGE <name>
Copy
Parameters¶name
Specifies the identifier of the application package.
LIKE 'pattern'
Optionally filters the command output by the version name specified in the application package. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).
For example, the following patterns return the same results:
... LIKE '%v1%' ...
... LIKE '%V1%' ...
. Default: No value (no filtering is applied to the output).
The command output provides release directive properties and metadata in the following columns:
Column
Description
NAME
Specifies the name of the release directive. For the default release directive, the name is DEFAULT.
TARGET_TYPE
Specifies the type of target for the directive. Possible values are:
DEFAULT
ACCOUNT
TARGET_NAME
Specifies the name of the organization or account. The value for the default release directive is always NULL.
CREATED_ON
Specifies the timestamp when the release directive was created.
VERSION
Specifies the application version literal if applicable, NULL otherwise.
PATCH
Specifies the patch number of the application version if applicable, NULL otherwise.
MODIFIED_ON
Specifies the timestamp when the release directive was last modified or NULL if it hasn’t been modified.
ACTIVE_REGIONS
Specifies the list of Snowflake regions where the release directive is allowed to affect upgrades. This value is ignored when RELEASE_STATUS is HOLDING.
PENDING_REGIONS
Specifies the list of Snowflake regions where the release directive will be applied in future. Upgrade progress in active regions is monitored for a period before new regions are activated.
RELEASE_STATUS
Specifies the current release status. Possible values are:
IN_PROGRESS: Upgrades are proceeding in the listed ACTIVE_REGIONS.
HOLDING: Upgrades are temporarily suspended.
DEPLOYED: Upgrades are permitted in all regions where the app is installed.
DEPLOYED_ON
Specifies the time and date the release directive was deployed. When too many target regions are identified as unhealthy during deployment, the release directive temporarily moves to HOLDING.
This command requires either the OWNERSHIP privilege on the application, or either the MANAGE RELEASES or the MANAGE VERSIONS privilege on the application package.
The command returns results for release directives that match the privileges granted to the role that executes this command.
The command doesn’t require a running warehouse to execute.
The command only returns objects for which the current user’s current role has been granted at least one access privilege.
The MANAGE GRANTS access privilege implicitly allows its holder to see every object in the account. By default, only the account administrator (users with the ACCOUNTADMIN role) and security administrator (users with the SECURITYADMIN role) have the MANAGE GRANTS privilege.
To post-process the output of this command, you can use the pipe operator (->>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query.
The output column names for this command are generated in lowercase. If you consume a result set from this command with the pipe operator or the RESULT_SCAN function, use double-quoted identifiers for the column names in the query to ensure that they match the column names in the output that was scanned. For example, if the name of an output column is type, then specify "type" for the identifier.
SHOW RELEASE DIRECTIVES IN APPLICATION PACKAGE hello_snowflake_package;
Copy
+---------+-------------+---------------------------------+-------------------------------+---------+-------+-------------------------------+------------------------+--------------------------+----------------+-------------------------------+ | name | target_type | target_name | created_on | version | patch | modified_on | active_regions | pending_regions | release_status | deployed_on | |---------+-------------+---------------------------------+-------------------------------+---------+-------+-------------------------------+------------------------+--------------------------+----------------+-------------------------------+ | DEFAULT | DEFAULT | NULL | 2023-04-02 14:55:17.304 -0700 | V2 | 0 | 2023-04-02 15:47:08.673 -0700 | PUBLIC.AWS_AP_SOUTH_1 | PUBLIC.AWS_AP_SOUTH_1 | IN PROGRESS | | | NEW_RD | ACCOUNT | [PROVIDER_DEV.PROVIDER_AWS] | 2023-04-02 16:30:44.443 -0700 | V1 | 1 | 2023-04-03 07:10:42.428 -0700 | ALL | | DEPLOYED | 2023-04-03 07:10:42.428 -0700 | | +---------+-------------+---------------------------------+-------------------------------+---------+-------+-------------------------------+------------------------+--------------------------+----------------+-------------------------------+
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