<budget_name>!GET_CONFIG

View the configuration properties for a budget.

语法

<budget_name>!GET_CONFIG()

返回

该函数返回以下列：

Column NameData TypeDescription
NOTIFICATION_EMAILVARCHAR

接收预算通知的电子邮件地址。如果有多个电子邮件地址，该函数将返回逗号分隔列表。

LAST_NOTIFICATION_TIMENUMBER

UTC timestamp when the last notification was sent. If no notifications were sent out yet, the value in this column is -1.

SPEND_LIMITNUMBERThe spending limit (in credits) for the budget.
NOTIFICATION_MUTE_FLAGBOOLEANTRUE if notifications are muted for the budget.
BUDGET_TYPEVARCHARType of budget. Valid values are: ACCOUNT_ROOT_BUDGET or USER_BUDGET
IS_ACTIVEBOOLEAN

TRUE，如果账户预算已激活。

此列仅适用于账户预算。

ACTIVATION_TIMESTAMPTIMESTAMP_TZ

账户预算的激活日期和时间。

此列仅适用于账户预算。

访问控制要求

  • 查看 自定义预算 的结果需要以下最低权限和角色：

    • Any instance role for the budget.
    • 对包含预算实例的数据库和架构的 USAGE 权限。

  • 需要以下角色才能查看 账户预算 的结果：

    Any application role for the account budget.

For more information, see Budgets roles and privileges.

使用说明

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.

示例

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

CALL budget_db.budget_schema.my_budget!GET_CONFIG();

查看账户预算的预算配置属性：

CALL snowflake.local.account_root_budget!GET_CONFIG();