<budget_name>!GET_NOTIFICATION_THRESHOLD

Returns the notification threshold for a budget. Notifications are sent when Snowflake predicts that spending will exceed the threshold, which is a percentage of the budget limit

Syntax

<budget_name>!GET_NOTIFICATION_THRESHOLD();
Copy

Returns

Returns a VARCHAR value containing the notification threshold percentage.

Access control requirements

The following minimum privileges and roles are required to call this method for custom budgets:

  • Any instance role for the budget instance.

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

The following minimum privileges and roles are required to call this method for the account budget:

For more information, see Budgets roles and privileges.

Usage notes

Calling this method does not return the object. Because of this, you can’t use method chaining to call another method on the return value of this method. Instead, call each method in a separate SQL statement.

Examples

Get the notification threshold for budget my_budget in schema budget_db.budget_schema:

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

Get the notification threshold for the account budget:

CALL SNOWFLAKE.LOCAL.ACCOUNT_ROOT_BUDGET!GET_NOTIFICATION_THRESHOLD();
Copy