Categories:

System functions (System Information)

SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT

指定在账户上启用还是禁用 Cross-Cloud Auto-Fulfillment。

See also:

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

语法

SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT( '<account_name>' )

实参

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.

返回

返回以下布尔值之一：

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

访问控制要求

示例

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