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.

语法

SYSTEM$APP_COMPATIBILITY_CHECK()

返回

返回一个包含 JSON 对象的 VARCHAR 值。此对象具有以下结构：

{
   "ACCOUNT_EDITION": "<service_level>"
}

Possible values for service_level are:

  • STANDARD
  • PREMIER
  • PREMIER_PLUS_1
  • PREMIER_PLUS_2
  • ENTERPRISE
  • BUSINESS_CRITICAL
  • VPS

使用说明

  • 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.

示例

确定使用者账户的 Snowflake 版本：

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

这表示使用者账户是 Standard Edition 账户。