SHOW VERSIONS¶
Lists the versions defined the the specified application package.
Syntax¶
SHOW VERSIONS [ LIKE <pattern> ]
IN APPLICATION PACKAGE <name>;
Parameters¶
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%' ...
IN APPLICATION PACKAGE name
Specifies the identifier for the application package whose versions you want to view.
Example¶
SHOW VERSIONS IN APPLICATION PACKAGE hello_snowflake_app;
+----------------+-------+---------+---------+-------------------------------+------------+-----------+-------------+-------+---------------+
| version | patch | label | comment | created_on | dropped_on | log_level | trace_level | state | review_status |
|----------------+-------+---------+---------+-------------------------------+------------+-----------+-------------+-------+---------------|
| V1_0 | 0 | NULL | NULL | 2023-05-10 17:11:47.696 -0700 | NULL | OFF | OFF | READY | NOT_REVIEWED |
+----------------+-------+---------+---------+-------------------------------+------------+-----------+-------------+-------+---------------+