Schema:

ACCOUNT_USAGE

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.