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