<budget_name>!GET_CONFIG

View the configuration properties for a budget.

Syntax

<budget_name>!GET_CONFIG()
Copy

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: 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.

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

View the budget configuration properties for the account budget:

CALL snowflake.local.account_root_budget!GET_CONFIG();
Copy