Schema:

ACCOUNT_USAGE

SNOWFLAKE_APP_RUNTIME_COMPUTE_HISTORY view

The SNOWFLAKE_APP_RUNTIME_COMPUTE_HISTORY view in the ACCOUNT_USAGE schema returns the hourly compute credit usage for Snowflake App Runtime in an account within the last 365 days (1 year).

All App Runtime apps in an account share Snowflake-managed compute, and the view reports credit usage at the account level. Per-app cost attribution isn’t available.

Columns

Column NameData TypeDescription
START_TIMETIMESTAMP_LTZThe date and beginning of the hour (in the local time zone) in which the usage took place.
END_TIMETIMESTAMP_LTZThe date and end of the hour (in the local time zone) in which the usage took place.
COMPUTE_POOL_NAMEVARCHARName of the Snowflake-managed compute pool that served the usage. Currently always SNOWFLAKE_APP_RUNTIME_COMPUTE.
CREDITS_USEDNUMBERNumber of credits used by Snowflake App Runtime in the hour.

Usage notes

  • Latency for the view may be up to 180 minutes (3 hours).
  • Credit usage reported here is also included in METERING_HISTORY and METERING_DAILY_HISTORY under the SNOWFLAKE_APP_RUNTIME service type.

Examples

Return daily Snowflake App Runtime credit usage for the last 30 days:

SELECT
    DATE(start_time) AS usage_date,
    SUM(credits_used) AS credits_used
FROM snowflake.account_usage.snowflake_app_runtime_compute_history
WHERE start_time >= DATEADD('day', -30, CURRENT_TIMESTAMP())
GROUP BY usage_date
ORDER BY usage_date DESC;