评估混合表的成本

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 的使用情况:

Time Travel 数据的混合表存储

混合表存储的使用量会考虑由 Time Travel 保留的数据。由 Time Travel 保留的数据包含在以下存储指标中:

Time Travel 保留的数据存储在对象存储中(而不是行存储中),按标准表费率(而不是更高的混合表费率)收费。