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, Auto-fulfillment for listings

Syntax

SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT( '<account_name>' )

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

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');
+------------------------------------------------------------------------+
| SYSTEM$SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT('my_account') |
%------------------------------------------------------------------------%
| TRUE                                                                   |
+------------------------------------------------------------------------+