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 the UTC time zone) in which the warehouse usage took place.

END_TIME

TIMESTAMP_LTZ

The date and end of the hour (in the UTC time zone) 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).