配置 Egress Cost Optimizer¶
如果您是提供商,则可以对列表使用 Cross-Cloud Auto-Fulfillment(自动履行)来自动将您的数据产品复制到其他 Snowflake 区域,而无需手动复制数据。
本节介绍如何授权多区域共享以及如何为您的组织启用和禁用 Egress Cost Optimizer (ECO)。
启用 Egress Cost Optimizer¶
您可以在账户级别启用或禁用 ECO。如果已设置自动履行计划,则数据库中遵循账户计划的所有列表都会启用 ECO。
为整个账户启用或禁用 ECO¶
ECO 在组织级别获得授权后,通过执行以下操作为账户启用或禁用 ECO:
In the navigation menu, select Data sharing » Provider Studio.
选择 Settings 选项卡。
在 Cross-Cloud Auto-Fulfillment 窗格中,点击 Egress Cost Optimizer 旁边的开关以启用或禁用 ECO。
您可以通过执行 ALTER ACCOUNT 命令将 ENABLE_EGRESS_COST_OPTIMIZER 参数设置为 TRUE 来启用出口成本优化:
ALTER ACCOUNT SET ENABLE_EGRESS_COST_OPTIMIZER=TRUE;
要禁用出口成本优化,请将 ENABLE_EGRESS_COST_OPTIMIZER 参数设置为 FALSE:
ALTER ACCOUNT SET ENABLE_EGRESS_COST_OPTIMIZER=FALSE;
有关更多信息,请参阅 ALTER ACCOUNT。
ECO 的限制¶
Egress Cost Optimizer 需要增量数据摄取才能充分利用云缓存。
Egress Cost Optimizer 仅将云缓存用于通过自动履行进行的刷新。
Egress Cost Optimizer 仅在同一数据库中所有列表的整体出口成本得到优化时,才会使用云缓存。优化器算法在数据库级别(而非表级别)衡量列表的大小。
ECO is not supported for listings that include a Cortex Knowledge Extension (CKE).
Providers should be aware of the cost implications for replication with listings that have a CKE.
If a CKE is added to a listing that has ECO enabled, ECO will be automatically turned off, and the provider will be notified by email. With ECO turned off, costs associated with the listing can increase.
Similarly, if a CKE is added to a listing that's part of a replication group, then ECO will be turned off for all listings within that replication group. An email notification will be sent to the provider indicating that the ECO was turned off.