<budget_name>!GET_CONFIG¶
View the configuration properties for a budget.
Syntax¶
<budget_name>!GET_CONFIG()
Returns¶
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: |
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. |
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 budget configuration properties for my_budget
in schema budget_db.budget_schema
:
CALL budget_db.budget_schema.my_budget!GET_CONFIG();
View the budget configuration properties for the account budget:
CALL snowflake.local.account_root_budget!GET_CONFIG();