Categories:

System functions (System Control)

SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT

Disables Cross-Cloud Auto-Fulfillment on an account.

See also:

SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT , SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT, Auto-fulfillment for listings

Syntax

SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT( '<account_name>' )

Arguments

account_name

The name of the account on which to disable Cross-Cloud Auto-Fulfillment. This is the account name only (for example, my_account), which is the value returned by CURRENT_ACCOUNT_NAME(). Do not pass the full account identifier used in account URLs or SQL (such as myorg-my_account or myorg.my_account). To learn more about Snowflake account identifiers, see Account identifiers.

Returns

Returns the VARCHAR value Statement executed successfully if the function successfully disables Cross-Cloud Auto-Fulfillment on the account.

Access control requirements

Examples

To retrieve the account name to pass to this function, call CURRENT_ACCOUNT_NAME():

SELECT CURRENT_ACCOUNT_NAME();

The following example disables Cross-Cloud Auto-Fulfillment on the account named my_account:

SELECT SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT('my_account');

+--------------------------------------------------------------+
| SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT('my_account') |
|--------------------------------------------------------------|
| Statement executed successfully                              |
+--------------------------------------------------------------+