Categories:

System functions (System Information)

SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES¶

Returns a JSON object containing a list of restricted features that the consumer has allowed a Snowflake Native App to use.

语法

SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES( '<app_name>' )

实参

app_name

Name of the Snowflake Native App.

Note

当应用程序调用系统函数时，将忽略此实参。

返回

返回 JSON 格式的字符串，其中列出了应用程序允许的所有受限功能设置。JSON 格式的字符串具有以下结构：

"{""external_data"":{""allowed_cloud_providers"":""all""}}"

使用说明

• When an app runs this system function, the app_name parameter is not required and is ignored if provided. In this context, all the apps restricted features are listed.
• When a provider or consumer runs this system function, app_name parameter is required and lists the restricted features of the app and whether they are enabled or not.

示例

要调用此函数，请使用以下语句：

SELECT SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES('hello_snowflake_app');

示例输出：

[
    {"external_data":{"allowed_cloud_providers":"all"}}
]