<budget_name>!GET_MEASUREMENT_TABLE¶
View the credit usage data collected by the budget maintenance task. For more information, see Understanding Cost for Budgets.
Syntax¶
<budget_name>!GET_MEASUREMENT_TABLE()
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.
Returns¶
The function returns the following columns:
Column Name |
Data Type |
Description |
---|---|---|
MEASUREMENT_TIME |
NUMBER |
UTC timestamp when the measurement was taken. |
SERVICE_TYPE |
VARCHAR |
Type of service that is consuming credits, which can be one of the following:
|
CREDITS_SPENT |
NUMBER |
Number of credits spent. |
UPDATED_TIME |
NUMBER |
UTC timestamp when the measurement was updated. |
Examples¶
View the credit usage data collected for budget my_budget
in schema budget_db.budget_schema
:
CALL budget_db.budget_schema.my_budget!GET_MEASUREMENT_TABLE();
View the credit usage data collected for the account budget:
CALL snowflake.local.account_root_budget!GET_MEASUREMENT_TABLE();