- Schemas:
METERING_DAILY_HISTORY View¶
The METERING_DAILY_HISTORY view in the ACCOUNT_USAGE schema can be used to return the daily credit usage and a cloud services rebate for an account within the last 365 days (1 year).
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
SERVICE_TYPE |
TEXT |
The type of service, which can be one of |
USAGE_DATE |
TIMESTAMP_LTZ |
The date (in the UTC time zone) in which the usage took place. |
CREDITS_USED_COMPUTE |
NUMBER |
Number of credits billed for virtual warehouses in the day. |
CREDITS_USED_CLOUD_SERVICES |
NUMBER |
Number of credits billed for cloud services in the day. |
CREDITS_USED |
NUMBER |
Sum of CREDITS_USED_COMPUTE and CREDITS_USED_CLOUD_SERVICES. |
CREDITS_ADJUSTMENT_CLOUD_SERVICES |
NUMBER |
Number of credits adjusted for included cloud services. This is a negative value (e.g. |
CREDITS_BILLED |
NUMBER |
Total number of credits billed for the account in the day. This is a sum of CREDITS_USED_COMPUTE, CREDITS_USED_CLOUD_SERVICES, and CREDITS_ADJUSTMENT_CLOUD_SERVICES. |
- 1
Query Acceleration Service is available for preview on request for accounts Enterprise Edition (or higher) in some regions.
Usage Notes¶
Latency for the view may be up to 180 minutes (3 hours).