Categories:

System functions (System Control)

SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT

Enables Cross-Cloud Auto-Fulfillment on an account. Cross-Cloud Auto-Fulfillment allows you to automatically provide the share or application package attached to your listing to other Snowflake consumer regions.

See also:

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

Syntax

SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT( '<account_name>' )

Arguments

account_name

The name of the account on which to enable 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 enables 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 enables Cross-Cloud Auto-Fulfillment on the account named my_account:

SELECT SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT('my_account');

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