DESCRIBE APPLICATION

Displays information about an application created with the Native Apps Framework.

DESCRIBE can be abbreviated to DESC.

See also:

ALTER APPLICATION PACKAGE, CREATE APPLICATION PACKAGE, DROP APPLICATION PACKAGE, SHOW APPLICATION PACKAGES,

Syntax

DESC[RIBE] APPLICATION <name>
Copy

Parameters

name

Specifies the identifier of the application to describe.

Output

The command provides application properties in the following columns:

Column

Description

property

The name of the property of the application. This column can include the properties listed in the following table.

value

The value assigned to the property of the application.

The property column can include the following properties of an application:

Property

Description

name

The name of the application.

source_organization

The name of the organization of the account containing the application package used to create the application.

source_account

The account of the application package used to create the application.

source_type

The source used to create the application. Valid values are APP_PACKAGE and LISTING.

source

The name of the application package or listing used to create the application.

version

The version identifier of the application.

version_label

The version label of the application that is visible to the consumer.

patch

The patch number of the application.

created_on

The timestamp when the application was installed.

last_upgraded_on

The timestamp of the last upgrade of the application.

share_events_with_provider

Indicates whether logging and event sharing is enabled for the application.

log_level

The log level set for the application.

trace_level

The trace level set for the application.

debug_mode

Indicates whether the application was created using debug mode.

upgrade_state

The current state of the application upgrade.

upgrade_target_version

The version identifier to which the application is being upgraded.

upgrade_target_patch

The patch to which the application is being upgraded.

upgrade_attempt

Indicates whether an upgrade was attempted for the application.

upgrade_task_id

The internal task identifier for the upgrade attempt.

upgrade_started_on

The timestamp when the application upgrade was initiated.

upgrade_attempted_on

The timestamp when the application was last upgraded.

upgrade_failure_reason

The reason the upgrade failed, if applicable.

previous_version

The identifier of the previous version of the installed application.

previous_patch

The number of the previous patch of the installed application.

previous_version_state

The state of the previous version of the application.

Usage Notes

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

Examples

Describe the properties of an installed application:

DESC APPLICATION hello_snowflake_app;
Copy
+----------------------------+-------------------------------+
| property                   | value                         |
|----------------------------+-------------------------------|
| name                       | hello_snowflake_app           |
| source_organization        | my_organization               |
| source_account             | provider_account              |
| source_type                | APPLICATION PACKAGE           |
| source                     | hello_snowflake_package       |
| version                    | v1_0                          |
| version_label              | NULL                          |
| patch                      | 0                             |
| created_on                 | 2023-05-25 08:30:41.520 -0700 |
| last_upgraded_on           |                               |
| share_events_with_provider | FALSE                         |
| log_level                  | OFF                           |
| trace_level                | OFF                           |
| debug_mode                 | FALSE                         |
| upgrade_state              | COMPLETE                      |
| upgrade_target_version     | NULL                          |
| upgrade_target_patch       | 0                             |
| upgrade_attempt            | NULL                          |
| upgrade_task_id            | NULL                          |
| upgrade_started_on         |                               |
| upgrade_attempted_on       |                               |
| upgrade_failure_reason     | NULL                          |
| previous_version           | NULL                          |
| previous_patch             | 0                             |
| previous_version_state     | COMPLETE                      |
+----------------------------+-------------------------------+