Categories:: File functions

SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS¶

Enables a restricted feature for a Snowflake Native App. Currently, only external and iceberg tables are supported.

Syntax¶

SET_APPLICATION_RESTRICTED_FEATURE_ACCESS('<app_name>', '<type>', '<parameters>')

Copy

Arguments¶

app_name

Name of the Snowflake Native App.

type

The type of restricted feature. Currently only EXTERNAL_DATA is supported.

parameters

A JSON object that contains configuration parameters for the restricted feature. Currently, only JSON objects of the following format are supported:

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

Copy

The supported values for allowed_cloud_providers are all and none.

Returns¶

A JSON object containing a list of external features whose value the consumer has set. The JSON object has the following structure:

"{""external_data"":{""allowed_cloud_providers"":""none""}}"

Copy

Examples¶

To call the function:

SELECT SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS('hello_snowflake_app', 'external_data', '{"allowed_cloud_providers" : "none"}');

Copy

Sample output:

"SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS('EXTERNAL_DATA_DEMO_APP', 'EXTERNAL_DATA', '{""ALLOWED_CLOUD_PROVIDERS"" : ""NONE""}')"
"{""external_data"":{""allowed_cloud_providers"":""none""}}"