Which system table will you use to get the total credit consumption over a specific time period?

Which system table will you use to get the total credit consumption over a specific time period?
A . WAREHOUSE_METERING_HISTORY
B. WAREHOUSE_CREDIT_USAGE_HISTORY
C. WAREHOUSE_USAGE_HISTORY

View Answer

Answer: A

Explanation

The WAREHOUSE_METERING_HISTORY table in the ACCOUNT_USAGE Schema can be used to get the desired information. Run the below query to try this out.

SELECT WAREHOUSE_NAME, SUM(CREDITS_USED_COMPUTE) AS CREDITS_USED_COMPUTE_SUM

FROM ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY

GROUP BY 1

ORDER BY 2 DESC;