DESCRIBE APPLICATION¶
Displays information about a Snowflake Native App.
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>
Parameters¶
name
Specifies the identifier of the app to describe.
Output¶
The command displays properties of an app in the following columns:
Column |
Description |
---|---|
|
The name of the property of the app. This column can include the properties listed in the following table. |
|
The value assigned to the property of the app. |
The property
column can include the following properties of an app:
Property |
Description |
---|---|
|
The name of the app. |
|
The name of the organization of the account containing the application package used to create the app. |
|
The account of the application package used to create the app. |
|
The source used to create the application. Valid values are |
|
The name of the application package or listing used to create the app. |
|
The version identifier of the app. |
|
The version label of the app. This label is visible to consumer when they install a Snowflake Native App. |
|
The patch number of the app. |
|
The timestamp when the app was created. |
|
The timestamp of the last upgrade of the app. |
|
Indicates whether logging and event sharing is enabled for the app. |
|
The status of the |
|
The log level defined by the provider in the manifest file. |
|
The trace level defined by the provider in the manifest file. |
|
The log level enabled for the app. |
|
The trace level enabled for the app. |
|
Indicates whether the application was created using debug mode. |
|
Indicates that the provider has scheduled an upgrade to begin at this time. However, the app may be upgraded before this date and time. For more information, see Manually upgrade an app. |
|
The current state of the background installation or upgrade of the app. Valid values are:
|
|
The version identifier to which the app is being upgraded. |
|
The patch to which the app is being upgraded. |
|
Indicates whether an upgrade was attempted for the app. |
|
The internal task identifier for the upgrade attempt. |
|
The timestamp when the upgrade was initiated. |
|
The timestamp for the last application installation or retry attempt. |
|
The reason for an upgrade failure. Possible values are:
|
|
The reason the upgrade failed, if applicable. |
|
The identifier of the previous version of the app. |
|
The number of the previous patch of the installed app. |
|
The state of the previous version of the app. |
|
Text that provides information about the app. |
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 app:
DESC APPLICATION hello_snowflake_app;
+------------------------------------+-------------------------------+
| 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 | 2024-05-25 08:30:41.520 -0700 |
| last_upgraded_on | |
| share_events_with_provider | FALSE |
| authorize_telemetry_event_sharing | 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_type | NULL |
| upgrade_failure_reason | NULL |
| previous_version | NULL |
| previous_patch | 0 |
| previous_version_state | COMPLETE |
| comment | |
+------------------------------------+-------------------------------+