- Schema:
APPLICATION_
The APPLICATION_SPECIFICATIONS displays a list of all app specifications created your Snowflake account. Each row in the view represents an app specification. Deleted app specifications are also included in the view. Because an app specification can be deleted and recreated with the same name. To differentiate between app specifications with the same name, use the ID column.
The retention time for deleted app specifications is 365 days. Data older than 365 days will not be available in the view.
Columns¶
The following table provides definitions for the APPLICATION_SPECIFICATIONS view columns.
| Column | Data type | Description |
|---|---|---|
| ID | NUMBER | An internal, system-generated identifier for the app specification. |
| NAME | TEXT | The name of the app specification. |
| APPLICATION_ID | NUMBER | An internal, system-generated identifier for the app that contains the app specification. |
| APPLICATION_NAME | TEXT | The name of the app that contains the app specification. |
| CREATED | TIMESTAMP_LTZ | The timestamp when the app specification was created. |
| DELETED | TIMESTAMP_LTZ | The timestamp when the app specification was deleted. This value is NULL if the app specification has not been deleted. |
| TYPE | TEXT | The type of app specification. Possible values are EXTERNAL_ACCESS, SECURITY_INTEGRATION, and LISTING. |
| SEQUENCE_NUMBER | NUMBER | The sequence number of the app specification. |
| REQUESTED_ON | TIMESTAMP_LTZ | The timestamp when the app created the app specification. |
| STATUS | TEXT | The status of the app specification. Possible values are: APPROVED, PENDING, or DECLINED. |
| STATUS_UPDATED_ON | TIMESTAMP_LTZ | The timestamp when the app specification was last updated, including when it was created, approved, or declined. |
| LABEL | TEXT | A label containing the name of the app specification that is displayed to consumer in Snowsight. |
| DESCRIPTION | TEXT | A description of the app specification. This description is displayed to the consumer. |
| DEFINITION | TEXT | The fields that comprise the app specification definition. For more information, |