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

Specifies the account on which to enable Cross-Cloud Auto-Fulfillment. To learn more about Snowflake account identifiers and how to locate them, 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

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                                    |
+--------------------------------------------------------------------+