Categories:: System functions (System Information)

SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT¶

Specifies whether Cross-Cloud Auto-Fulfillment is enabled or disabled on an account.

See also:: SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT, SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT, Configuring Cross-Cloud Auto-Fulfillment

Syntax¶

SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT( '<account_name>' )

Copy

Arguments¶

account_name: Specifies the account on which you want to determine if Cross-Cloud Auto-Fulfillment is enabled or disabled. To learn more about Snowflake account identifiers and how to locate them, see Account identifiers.

Returns¶

Returns one of the following Boolean values:

TRUE (if Cross-Cloud Auto-Fulfillment is enabled for the current account)
FALSE (if Cross-Cloud Auto-Fulfillment is disabled for the current account)

Access control requirements¶

Only organization administrators can execute this function.

Examples¶

The following example determines if Cross-Cloud Auto-Fulfillment is enabled on the account named my_account:

SELECT SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT('my_account');

Copy

+------------------------------------------------------------------------+
| SYSTEM$SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT('my_account') |
|------------------------------------------------------------------------|
| TRUE                                                                   |
+------------------------------------------------------------------------+