DESCRIBE APPLICATION¶
Displays information about an application object.
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 application object to describe.
Output¶
The command displays properties of an application object in the following columns:
Column |
Description |
---|---|
|
The name of the property of the application object. This column can include the properties listed in the following table. |
|
The value assigned to the property of the application object. |
The property
column can include the following properties of an application object:
Property |
Description |
---|---|
|
The name of the application object. |
|
The name of the organization of the account containing the application package used to create the application object. |
|
The account of the application package used to create the application object. |
|
The source used to create the application. Valid values are |
|
The name of the application package or listing used to create the application object. |
|
The version identifier of the application object. |
|
The version label of the application object. This label is visible to consumer when they install a Snowflake Native App. |
|
The patch number of the application object. |
|
The timestamp when the application object was created. |
|
The timestamp of the last upgrade of the application object. |
|
Indicates whether logging and event sharing is enabled for the application object. |
|
The status of the |
|
The log level set for the application object. |
|
The trace level set for the application object. |
|
Indicates whether the application was created using debug mode. |
|
The current state of the background installation or upgrade of the application object. Valid values are:
|
|
The version identifier to which the application object is being upgraded. |
|
The patch to which the application object is being upgraded. |
|
Indicates whether an upgrade was attempted for the application object. |
|
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 application object. |
|
The number of the previous patch of the installed application object. |
|
The state of the previous version of the application object. |
|
Text that provides information about the application object. |
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 application object:
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 | |
+------------------------------------+-------------------------------+