<budget_name>!GET_SPENDING_HISTORY¶
View the spending history for a budget.
- See also:
Syntax¶
<budget_name>!GET_SPENDING_HISTORY( [ TIME_LOWER_BOUND => <constant_expr> ,
TIME_UPPER_BOUND => <constant_expr> ] )
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:
|
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();
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()
);