了解复制成本
基于复制的费用分为两类:数据传输和计算资源。这两类费用均对目标账户(即,存储刷新的辅助数据库或辅助复制/故障转移组的账户)计费。
- Data transfer:
初始复制和后续同步操作会在区域之间传输数据。如果数据从一个区域传输到云提供商自己网络内的另一个区域,云提供商会收取费用。
The data transfer rate is determined by the location of the source account (i.e. the account that stores the primary replication or failover group). For data transfer pricing, see the Snowflake Service Consumption Table.
For more information, see Understanding data transfer cost.
- Compute resources:
复制操作使用 Snowflake 提供的计算资源进行以下操作:
- 确定在刷新操作期间要复制的元数据和数据的增量。
- 在不同区域的账户之间复制数据。
The service type for compute costs for replication in the account usage and organization usage views is REPLICATION.
For more information, see Understanding compute cost.
Note
- 对于该账户中各个辅助数据库中的数据,目标账户还会产生标准存储成本。
- The target account also incurs costs for the automatic background processes that service materialized views and search optimization. For details, see the “Serverless Feature Credit Table” in the Snowflake Service Consumption Table for the costs per compute hour.
- Replication charges are applied even if the initial replication or a refresh operation doesn’t succeed. Any data that is copied before the initial replication or refresh operation fails can be reused by a subsequent refresh operation (if performed within 14 days) and doesn’t need to be copied again.
估算和控制成本
通常,复制的每月计费与以下因素成比例:
- Amount of table data in the primary database, or databases in a replication/failover group, that changes as a result of data loading or DML operations.
- 从主数据库或复制/故障转移组刷新辅助数据库或复制/故障转移组的频率。
您可以通过仔细选择要复制的数据库或对象及其刷新频率来控制复制成本。您可以通过停止刷新操作来停止产生复制成本。
查看实际成本
具有 ACCOUNTADMIN 角色的用户可以使用 SQL 来查看在指定日期范围内,Snowflake 账户中通过复制组或故障转移组进行复制时所传输的数据量(以字节为单位)和复制产生的 Credit 使用量。
Users with the ACCOUNTADMIN role can use Snowsight or SQL to view the amount of replication data transferred (in bytes) for your Snowflake account within a specified date range.
- Snowsight:
In the navigation menu, select Admin » Cost management.
要查看您的账户中与复制相关的数据传输量和 Credit 使用量,请执行以下操作:
- SQL:
查询以下任一内容:
- REPLICATION_GROUP_USAGE_HISTORY table function (in the Snowflake Information Schema). This function returns replication usage activity within the last 14 days.
- REPLICATION_GROUP_USAGE_HISTORY view (in Account Usage). This view returns replication usage activity within the last 365 days (1 year).
For examples, see Monitor replication costs.
To view the cost of replication for individual databases replicated with Database Replication, see Monitoring database replication cost.