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.