- Schema:
WAREHOUSE_
This Organization Usage view can be used to return the hourly credit usage for one or more warehouses across all the accounts in your organization within the last 365 days (1 year).
Columns¶
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization where the usage took place. |
| ACCOUNT_NAME | VARCHAR | Name of the account where the usage took place. |
| REGION | VARCHAR | Name of the region where the account is located. |
| SERVICE_TYPE | VARCHAR | The type of service, which identifies whether the usage is for a standard or reader account. Valid values: WAREHOUSE_METERING or WAREHOUSE_METERING_READER. |
| START_TIME | TIMESTAMP_LTZ | The date and beginning of the hour (in the local time zone) in which the warehouse usage took place. |
| END_TIME | TIMESTAMP_LTZ | The date and end of the hour (in the local time zone) in which the warehouse usage took place. |
| WAREHOUSE_ID | NUMBER | Internal/system-generated identifier for the warehouse. |
| WAREHOUSE_NAME | VARCHAR | Name of the warehouse. |
| CREDITS_USED | NUMBER | Total number of credits used by the warehouse in the hour. This is the sum of CREDITS_USED_COMPUTE and CREDITS_USED_CLOUD_SERVICES. This value does not take into account the adjustment for cloud services, and may therefore be greater than the credits that are billed. To determine how many credits were actually billed, run queries against the METERING_DAILY_HISTORY view. |
| CREDITS_USED_COMPUTE | NUMBER | Number of credits used for the warehouse in the hour. |
| CREDITS_USED_CLOUD_SERVICES | NUMBER | Number of credits used for cloud services in the hour. |
| ACCOUNT_LOCATOR | VARCHAR | Locator for the account where the usage took place. |
Usage notes¶
- Latency for the view may be up to 1440 minutes (24 hours).