Schemas:
ACCOUNT_USAGE , READER_ACCOUNT_USAGE

WAREHOUSE_METERING_HISTORY View

This Account Usage view can be used to return the hourly credit usage for a single warehouse (or all the warehouses in your account) within the last 365 days (1 year).

Columns

Column Name Data Type Description
READER_ACCOUNT_NAME TEXT Name of the reader account where the warehouse usage took place. Column only included in view in READER_ACCOUNT_USAGE schema.
START_TIME TIMESTAMP_LTZ The date and beginning of the hour in which the warehouse usage took place.
END_TIME TIMESTAMP_LTZ The date and end of the hour in which the warehouse usage took place.
WAREHOUSE_ID NUMBER Internal/system-generated identifier for the warehouse.
WAREHOUSE_NAME TEXT Name of the warehouse.
CREDITS_USED NUMBER Number of credits billed for the warehouse in the hour.

Usage Notes

  • Latency for the view may be up to 180 minutes (3 hours).