<budget_name>!GET_CONFIG¶

View the configuration properties for a budget.

Syntax¶

<budget_name>!GET_CONFIG()

Copy

The function returns the following columns:

Column Name	Data Type	Description
NOTIFICATION_CHANNEL	NUMBER	Internal/system identifier for the notification integration.
NOTIFICATION_EMAIL	VARCHAR	The email address(es) that receive budget notifications. If there is more than one email address, the function returns a comma-separated list.
LAST_NOTIFICATION_TIME	NUMBER	UTC timestamp when the last email notification was sent.
SPEND_LIMIT	NUMBER	The spending limit (in credits) for the budget.
NOTIFICATION_MUTE_FLAG	BOOLEAN	TRUE if email notifications are muted for the budget.
BUDGET_TYPE	VARCHAR	Type of budget. Valid values are: `ACCOUNT_ROOT_BUDGET` or `USER_BUDGET`
IS_ACTIVE	BOOLEAN	TRUE if the account budget has been activated. This column is only available for the account budget.
ACTIVATION_TIMESTAMP	TIMESTAMP_TZ	Date and time the account budget was activated. This column is only available for the account budget.

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.

View the budget configuration properties for my_budget in schema budget_db.budget_schema:

CALL budget_db.budget_schema.my_budget!GET_CONFIG();

Copy

View the budget configuration properties for the account budget:

CALL snowflake.local.account_root_budget!GET_CONFIG();

Copy