<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()

Copy

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.

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: `AUTO_CLUSTERING` `MATERIALIZED_VIEW` `PIPE` `QUERY_ACCELERATION` `SEARCH_OPTIMIZATION` `SERVERLESS_TASK` `SNOWPIPE_STREAMING` `WAREHOUSE_METERING` `WAREHOUSE_METERING_READER`
CREDITS_SPENT	NUMBER	Number of credits spent.
UPDATED_TIME	NUMBER	UTC timestamp when the measurement was updated.

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();

Copy

View the credit usage data collected for the account budget:

CALL snowflake.local.account_root_budget!GET_MEASUREMENT_TABLE();

Copy