SHOW RELEASE DIRECTIVES¶
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 wish to filter the results using the provided filters.
- See also:
ALTER APPLICATION PACKAGE, CREATE APPLICATION PACKAGE, DROP APPLICATION PACKAGE, SHOW APPLICATION PACKAGES
Syntax¶
SHOW RELEASE DIRECTIVES [ LIKE '<pattern>' ]
IN APPLICATION PACKAGE <name>
Parameters¶
name
Specifies the identifier of the application package.
LIKE 'pattern'
Filters the command output by object name. The filter uses case-insensitive pattern matching with support for SQL wildcard characters (
%
and_
).For example, the following patterns return the same results:
... LIKE '%testing%' ...
... LIKE '%TESTING%' ...
Usage Notes¶
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.
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
|
TARGET_TYPE |
Specifies the type of target for the directive. Possible values are:
|
TARGET_NAME |
Specifies the name of the organization or account. The value for the default release
directive is always |
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. |
Examples¶
SHOW RELEASE DIRECTIVES IN APPLICATION PACKAGE hello_snowflake_package;
+---------+-------------+---------------------------------+-------------------------------+---------+-------+-------------------------------+
| name | target_type | target_name | created_on | version | patch | modified_on |
|---------+-------------+---------------------------------+-------------------------------+---------+-------+-------------------------------|
| DEFAULT | DEFAULT | NULL | 2023-04-02 14:55:17.304 -0700 | V2 | 0 | 2023-04-02 15:47:08.673 -0700 |
| 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 |
+---------+-------------+---------------------------------+-------------------------------+---------+-------+-------------------------------+