Snowflake Native App Framework: Changes to the SHOW APPLICATION and DESC APPLICATION commands

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