- Schema:
SNOWPARK_CONTAINER_SERVICES_HISTORY View¶
The SNOWPARK_CONTAINER_SERVICES_HISTORY view in the ACCOUNT_USAGE schema can be used to return the hourly compute pool credit usage for an account within the last 365 days (1 year).
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
START_TIME |
TIMESTAMP_LTZ |
The date and beginning of the hour (in the local time zone) in which the usage took place. |
END_TIME |
TIMESTAMP_LTZ |
The date and end of the hour (in the local time zone) in which the usage took place. |
COMPUTE_POOL_NAME |
TEXT |
Name of the compute pool which incurred the credit usage. |
CREDITS_USED |
NUMBER |
Number of credits the compute pool used in the hour. |
Usage Notes¶
Latency for the view may be up to 180 minutes (3 hours).
The view provides hourly compute pool credit usage for an account within the last 365 days (1 year).
The credit rate usage is determined based on the machine type (instance family) of the compute pool, as outlined in the consumption table.