<budget_name>!GET_LINKED_TAGS

List the tags that have been added to a custom budget.

Important

This method has been deprecated. Use <budget_name>!GET_BUDGET_SCOPE instead.

Syntax

<budget_name>!GET_LINKED_TAGS()

Returns

The method returns the following columns:

Column nameData typeDescription
TAG_IDNUMBERSystem-generated identifier.
TAG_VALUEVARCHARValue of the tag.
TAG_DATABASEVARCHARDatabase that contains the tag.
TAG_SCHEMAVARCHARSchema that contains the tag.
TAG_NAMEVARCHARName of the tag.

Access control requirements

The following minimum privileges and roles are required to view results for custom budgets:

  • ADMIN or VIEWER instance role for the budget instance.
  • USAGE privilege on the database and schema that contains the budget instance.

For more information, see Budgets roles and privileges.

Usage notes

  • This method can only be called on custom budget instances.

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

Example

Get all tags that were added to the budget_db.budget_schema.my_budget budget:

CALL budget_db.budget_schema.my_budget!GET_LINKED_TAGS();