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

The name of the account on which to determine whether Cross-Cloud Auto-Fulfillment is enabled. 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 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

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

SELECT CURRENT_ACCOUNT_NAME();

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