Categories:

System functions (Control)

SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS¶

Enables a restricted feature for a Snowflake Native App. Currently, only external and Apache Icebergâ„¢ tables are supported.

Syntax¶

SYSTEM$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""}}"
Language: English