<budget_name>!GET_LINKED_RESOURCES¶

List the objects in a custom budget.

Syntax¶

<budget_name>!GET_LINKED_RESOURCES()

Copy

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.

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.

This method can only be called on custom budget instances.

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