Schema:: DATA_SHARING_USAGE

APPLICATION_STATE view¶

This view in the DATA_SHARING_USAGE schema can be used to display information about apps installed from a listing for all application packages in the current account.

If a listing was published using Cross-Cloud Auto-Fulfillment, this view displays information for installed apps across all regions.

Columns¶

Column Name	Data Type	Description
CONSUMER_SNOWFLAKE_REGION	VARCHAR	The Snowflake region of the consumer account where the application is installed.
CONSUMER_ORGANIZATION_NAME	VARCHAR	The organization name of the consumer account.
CONSUMER_ACCOUNT_LOCATOR	VARCHAR	The consumer account locator.
CONSUMER_ACCOUNT_NAME	VARCHAR	The consumer account name.
PROVIDER_SNOWFLAKE_REGION	VARCHAR	The Snowflake region of the provider account that created the application package.
PROVIDER_ACCOUNT_LOCATOR	VARCHAR	The provider account locator.
PROVIDER_ACCOUNT_NAME	VARCHAR	The provider account name.
PACKAGE_NAME	VARCHAR	The current name for the application package in the provider’s account from which the application was installed.
APPLICATION_NAME_HASH	VARCHAR	The hash string of the name of the installed application instance in the consumer account. The consumer uses the SHA1 function to calculate the hash value of the installed application. The consumer can then use this value when contacting the provider.
CREATED_ON	DATETIME	The timestamp when the application instance was first installed.
CURRENT_VERSION	VARCHAR	The current version of the installed application.
CURRENT_PATCH	INT	The current patch level of the installed application.
CURRENT_INSTALLED_ON	DATETIME	The timestamp when the current application version was installed.
PREVIOUS_VERSION_STATE	VARCHAR	The state of the previous version. Possible values are COMPLETE and FINALIZING. `COMPLETE` indicates that upgrade is completed and that there are no active queries being executed from the previous version, if it exists. `FINALIZING` indicates that the instance has been upgraded from the previous version, however one or more queries may be still be running that are using the previous version.
PREVIOUS_VERSION	VARCHAR	The previous application version of the installed application.
PREVIOUS_PATCH	INT	The previous patch level of the application.
UPGRADE_STATE	VARCHAR	The version upgrade state of the application. Possible values are: `INSTALLING`: The application object is in the process of being created. `INSTALL_FAILED`: The creation of the application object failed. The application object remains in the `INSTALL_FAILED` state until it is dropped. See the `UPGRADE_FAILURE_REASON` column of the DESCRIBE APPLICATION command for information about why the installation or upgrade failed. `COMPLETE`: The setup script successfully completed and the application object was created or upgraded. `QUEUED`: The application object is queued for upgrade. `UPGRADING`: The application object is in the process of being upgraded. `FAILED`: All upgrade attempts failed. The reason for the failure is listed in the `UPGRADE_FAILURE_REASON` column, if present. The instance remains in the `FAILED` state until a release directive is updated to point to a different version than the one that the upgrade was targeting, as defined in the `TARGET_UPGRADE_VERSION` column. `QUEUED_RETRY`: The instance failed one or more upgrade attempts. The reason for the failure is indicated in `UPGRADE_FAILURE_REASON`: The instance is queued to perform another upgrade attempt. `DISABLED`: The application object and its upgrades were disabled. In this state the instance will be inaccessible for consumers, it will not be considered for upgrades and will not block application package version drop. The reason for the failure is listed in the `UPGRADE_FAILURE_REASON` column, if present.
TARGET_UPGRADE_VERSION	VARCHAR	The target version of the application that is running or pending upgrade.
TARGET_UPGRADE_PATCH	INT	The version patch level of the application that is running or pending upgrade.
UPGRADE_STARTED_ON	DATETIME	The timestamp when the application upgrade started.
UPGRADE_ATTEMPT	INT	The number of attempts to upgrade to the target version or patch.
UPGRADE_ATTEMPTED_ON	DATETIME	The timestamp when the most recent upgrade attempt was attempted.
UPGRADE_FAILURE_REASON	VARCHAR	A description of the failure if the previous application upgrade failed.
LISTING_NAME	VARCHAR	The name of the listing on the data exchange from which the application was installed.
LISTING_DISPLAY_NAME	VARCHAR	The display name of the listing.
EXCHANGE_NAME	VARCHAR	The data exchange name of the listing from which the application was installed.

Usage notes¶

There is no data retention for this view. If an application is uninstalled the information contained in this view is no longer available.