To retrieve total compute credits used by warehouses over a given period, which ACCOUNT_USAGE table should you query?

• A. Warehouse Credit Usage History
• B. Warehouse Usage History
• C. Warehouse Metering History
• D. Warehouse Credits History

Answer: (C)

To get the total compute credits used by warehouses over a period, you need the data that records actual credit consumption over time. The Warehouse Metering History view in ACCOUNT_USAGE provides per-warehouse credits consumed across time intervals, exactly the kind of metered usage data you aggregate to get a period total. By filtering to your start and end times and summing the credits field (across all warehouses), you obtain the total credits used in that window.

Other views in ACCOUNT_USAGE cover different aspects, such as runtime metrics or billed/allocated credits, which don’t reliably reflect actual consumption over a specific period. Therefore they aren’t the right source for calculating total compute credits used.