METERING_DAILY_HISTORY and WAREHOUSE_METERING_HISTORY generating different results

Viewed 25

I wanted to calculate credit used daily for all warehouses.

SELECT SUM(CREDITS_USED)
FROM ACCOUNT_USAGE.METERING_DAILY_HISTORY
WHERE USAGE_DATE='2022-09-19';

It is showing different result when using WAREHOUSE_METERING_HISTORY table, using below query:

SELECT SUM(CREDITS_USED)
FROM ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY
WHERE START_TIME BETWEEN '2022-09-19 00:00:00.000' AND
                         '2022-09-19 23:59:59.000' ;

METERING_DAILY_HISTORY table value is matching with Usage information in Account tab in classic worksheet, but WAREHOUSE_METERING_HISTORY is yielding result greater than actual usage information.

Kindly help me here what I am missing.

0 Answers
Related