SHOW VERSIONS

Lists the versions defined the the specified application package.

See also:

ALTER APPLICATION, CREATE APPLICATION, DESCRIBE APPLICATION, DROP APPLICATION

Syntax

SHOW VERSIONS [ LIKE <pattern> ]
  IN APPLICATION PACKAGE <name>;
Copy

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;
Copy
+----------------+-------+---------+---------+-------------------------------+------------+-----------+-------------+-------+---------------+
| 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  |
+----------------+-------+---------+---------+-------------------------------+------------+-----------+-------------+-------+---------------+