Categories:

System functions (System Information)

SYSTEM$APP_COMPATIBILITY_CHECK¶

Returns the Snowflake edition of the consumer account where an app is installed.

Note

This function can only be called by a Snowflake Native App.

Syntax¶

SYSTEM$APP_COMPATIBILITY_CHECK()
Copy

Returns¶

Returns a VARCHAR value containing a JSON object. This object has the following structure:

{
   "ACCOUNT_EDITION": "<service_level>"
}
Copy

Possible values for service_level are:

  • STANDARD

  • PREMIER

  • PREMIER_PLUS_1

  • PREMIER_PLUS_2

  • ENTERPRISE

  • BUSINESS_CRITICAL

  • VPS

Usage notes¶

  • Providers can use this function to determine the Snowflake edition of the account where the app is installed. For example, providers can call this function from the setup script to check for the edition during installation.

Examples¶

Determine the Snowflake edition for a consumer account:

SELECT SYSTEM$APP_COMPATIBILITY_CHECK();
Copy
{
  "ACCOUNT_EDITION": "STANDARD"
}
Copy

This indicates that the consumer account is a Standard Edition account.