- Schema:
SNOWPARK_
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 | VARCHAR | Name of the compute pool which incurred the credit usage. |
| IS_EXCLUSIVE | BOOLEAN | TRUE, if the compute pool was created for an application. |
| APPLICATION_NAME | VARCHAR | The name of the application for which the compute pool was created. NULL if the compute pool was not created for an application or if the application no longer exists. |
| APPLICATION_ID | VARCHAR | The ID of the application for which the compute pool was created; otherwise NULL. |
| 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.