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.

Language: English