评估混合表的成本¶
When you use hybrid tables, your account is charged based on two modes of consumption:
Hybrid table storage: Cost for storage of hybrid tables depends on the amount of data that you are storing. Storage cost is based on a flat monthly rate per gigabyte (GB). See Table 3(b) in the Snowflake Service Consumption Table, which covers unit pricing for hybrid table storage.
Note that hybrid table storage for the row-store copy of the data is more expensive than traditional Snowflake storage. The copy of the current data in the column store (object storage) is not billed.
Historical time travel data is billed at standard storage prices.
虚拟仓库计算:对混合表的查询通过虚拟仓库执行。查询混合表的仓库消耗率与查询标准表的消耗率相同。请参阅 虚拟仓库 Credit 使用量。
监控混合表的存储使用情况¶
您可以通过查询以下视图和函数来查看混合表的存储使用情况,并监控混合表存储 credit 的使用情况:
:doc:`/sql-reference/account-usage/storage_usage`(STORAGE_BYTES 和 HYBRID_TABLE_STORAGE_BYTES 列)。
DATABASE_STORAGE_USAGE_HISTORY(AVERAGE_HYBRID_TABLE_STORAGE_BYTES 和 AVERAGE_DATABASE_BYTES 列):
Account Usage DATABASE_STORAGE_USAGE_HISTORY 视图
Organization Usage DATABASE_STORAGE_USAGE_HISTORY 视图
Information Schema DATABASE_STORAGE_USAGE_HISTORY 函数
:doc:`/sql-reference/account-usage/hybrid_tables`(BYTES 列中特定混合表的数据)。
AGGREGATE_QUERY_HISTORY 视图:选择使用 时默认使用的角色和仓库。监控对混合表执行特定查询期间使用的虚拟仓库计算资源。请参阅 监控工作负载。
Time Travel 数据的混合表存储¶
混合表存储的使用量会考虑由 Time Travel 保留的数据。由 Time Travel 保留的数据包含在以下存储指标中:
STORAGE_USAGE 视图 中的 STORAGE_BYTES 列
DATABASE_STORAGE_USAGE_HISTORY 中的 AVERAGE_DATABASE_BYTES 列:
Account Usage DATABASE_STORAGE_USAGE_HISTORY 视图
Organization Usage DATABASE_STORAGE_USAGE_HISTORY 视图
Information Schema DATABASE_STORAGE_USAGE_HISTORY 函数
Time Travel 保留的数据存储在对象存储中(而不是行存储中),按标准表费率(而不是更高的混合表费率)收费。