<budget_name>!GET_LINKED_RESOURCES

List the objects in a custom budget.

See also:

<budget_name>!ADD_RESOURCE, <budget_name>!REMOVE_RESOURCE

Syntax

<budget_name>!GET_LINKED_RESOURCES()
Copy

Returns

The function returns the following columns:

Column Name

Data Type

Description

RESOURCE_ID

NUMBER

Internal identifier for the object.

NAME

VARCHAR

Name of the object.

DOMAIN

VARCHAR

Domain of the object. Valid values: TABLE

SCHEMA_NAME

VARCHAR

Name of the schema that contains the object.

DATABASE_NAME

VARCHAR

Name of the database that contains the object.

Access Control Requirements

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

  • A role with the ADMIN instance role for the budget instance.

  • A role granted the USAGE privilege on the database and schema that contains the budget instance.

Usage Notes

This method can only be called on custom budget instances.

Examples

Get all objects in the budget my_budget in schema budget_db.budget_schema:

CALL budget_db.budget_schema.my_budget!GET_LINKED_RESOURCES();
Copy