Users possessing the OWNERSHIP privilege for an application package can detach it from an account. However, it’s important to note that removing an application package associated with a listing is not permitted.
Once an application package is removed, it becomes inaccessible within the provider account.
Following the removal of both a listing and the associated application package, consumers can view but cannot access the Snowflake Native App generated from that application package. Attempting to access the Snowflake Native App results in an error indicating the removal of the application package.
Removing an application package can be done either through Snowsight or by utilizing SQL commands.
Removing an Application Package Using Snowsight:
To remove an application package using Snowsight, adhere to the following steps:
Sign in to Snowsight.
In the left navigation bar, navigate to Apps, and then select Packages.
Choose the ellipsis (…) next to the desired application package, then select Drop.
Removing an Application Package Using SQL Commands:
To remove an application package using SQL, execute the DROP APPLICATION PACKAGE command, as illustrated in the following example:
DROP APPLICATION PACKAGE HelloSnowflakePackage;