Snowflake Native App Framework: Changes to the SHOW APPLICATION and DESC APPLICATION commands (Pending)¶

Attention

This behavior change is in the 2024_07 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the output of the SHOW APPLICATIONS DESCRIBE APPLICATION commands include the following changes.

Changes to the SHOW APPLICATIONS command¶

The output of the SHOW APPLICATIONS command includes the following new columns:

Column name	Description
disablement_reasons	An array containing the reasons why the Snowflake Native App was disabled. See Possible statuses for a disabled app for the list of possible reasons.
last_upgraded_on	The timestamp of the last successful upgrade of the app. The timestamp is empty if there is no successful upgrade.

Changes to the DESCRIBE APPLICATION command¶

Before the change:

Previously, if an app is disabled, the DESCRIBE APPLICATION command returns an error code to indicate that the app is disabled.

After the change:

The DESCRIBE APPLICATION command succeeds and the reason the app is disabled is included in the output in a new column:

Column name	Description
disablement_reasons	An array containing the reasons why the Snowflake Native App was disabled. See Possible statuses for a disabled app for the list of possible reasons.

Possible statuses for a disabled app¶

The following table lists the possible values for the DISABLEMENT_REASONS column:

Value	Status description	Is recoverable?
MANUALLY_DISABLED	The app is disabled by Snowflake	Yes. To re-enable the app, contact Snowflake Support.
ACCOUNT_INACTIVE	The account becomes inactive by being locked or suspended causing the app to be unavailable. In this state a consumer cannot execute any SQL queries in their account and the app cannot be upgraded.	Yes. The app is automatically re-enabled if the account lock or suspension is removed
PACKAGE_VERSION_IS_MISSING	The application package version for the app was dropped by the provider. The app is no longer usable and must be dropped and reinstalled from a valid listing or application package	No the same name.
CMK_ACCESS_DENIED	The consumer manages the encryption key themselves (ENCRYPT_USE_CMK_KMS is enabled) and Snowflake doesn’t have access to this key.	Yes. To re-enable the app, ensure that the cloud provider configuration to retrieve the CMK is correct and that Snowflake has access to the key.
LISTING_ACCESS_REVOKED	The listing used to create the app is no longer available. Possible reasons for this status include: The provider deleted the listing The provider manually removed access to the private listing from the consumer account	Possibly. Recoverability depends on the reason why access was revoked. For example, if the listing was deleted it is not recoverable. If a consumer account was manually removed from the private listing, access to the listing and app can be restored.
LISTING_TRIAL_USAGE_EXCEEDED	The application has exceeded the usage limit for a usage-based trial listing.	No
LISTING_PAYMENT_REQUIRED	The listing used to install the app is a paid listing and requires payment for further usage.	Yes. The consumer must correctly set up payment for the app.
LISTING_TRIAL_TIME_EXCEEDED	The application exceeded the trial duration.	No
APPLICATION_PACKAGE_NOT_AVAILABLE	The application package used to create the app no longer exists. The provider may have dropped the corresponding application package.	No
APPLICATION_PACKAGE_DISABLED	The application package used to create the app is disabled by the Snowflake.	Yes. The app is re-enabled, if Snowflake re-enables the application package.
APPLICATION_SUSPENDED	The app resources for example, tasks, services, and compute pools, are suspended due to the app being disabled. The suspended objects remain suspended until the app is re-enabled and there are no other reasons the app was disabled.	Yes
APPLICATION_SUSPEND_RESUME_IN_PROGRESS	The app resources, for example tasks, services, and compute pools, are currently resuming.	Yes