<budget_name>!GET_SPENDING_HISTORY

View the spending history for a budget.

See also:

<budget_name>!GET_SERVICE_TYPE_USAGE

Syntax

<budget_name>!GET_SPENDING_HISTORY( [ TIME_LOWER_BOUND => <constant_expr> ,
                                      TIME_UPPER_BOUND => <constant_expr> ] )
Copy

Optional Arguments

TIME_LOWER_BOUND => constant_expr, . TIME_UPPER_BOUND => constant_expr

Time range (in UTC timestamp format) during which the spending occurred.

You must set both lower and upper time bounds to limit the results by a time range.

Returns

The function returns the following columns:

Column Name

Data Type

Description

MEASUREMENT_DATE

DATE

Date when the usage occurred.

SERVICE_TYPE

VARCHAR

Type of service that is consuming credits, which can be one of the following:

  • AUTO_CLUSTERING

  • MATERIALIZED_VIEW

  • PIPE

  • QUERY_ACCELERATION

  • SEARCH_OPTIMIZATION

  • SERVERLESS_TASK

  • SNOWPIPE_STREAMING

  • WAREHOUSE_METERING

  • WAREHOUSE_METERING_READER

CREDITS_SPENT

FLOAT

Number of credits used.

Access Control Requirements

  • The following minimum privileges and roles are required to view results for custom budgets:

    • A role with any instance role for the budget instance.

    • A role granted the USAGE privilege on the database and schema that contains the budget instance.

  • The following role is required to view results for the account budget:

    A role with any application role for the account budget.

Examples

View the spending history for budget my_budget in schema budget_db.budget_schema:

CALL budget_db.budget_schema.my_budget!GET_SPENDING_HISTORY();
Copy

View the spending history for the last 7 days for the account budget:

CALL snowflake.local.account_root_budget!GET_SPENDING_HISTORY(
  TIME_LOWER_BOUND=>dateadd('days', -7, current_timestamp()),
  TIME_UPPER_BOUND=>current_timestamp()
);
Copy