<budget_name>!GET_LINKED_RESOURCES¶
List the objects in a custom budget.
Syntax¶
<budget_name>!GET_LINKED_RESOURCES()
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:
|
SCHEMA_NAME |
VARCHAR |
Name of the schema that contains the object. NULL if the object is not a schema-level object. |
DATABASE_NAME |
VARCHAR |
Name of the database that contains the object. NULL if the object is not a database-level or schema-level object. |
Access control requirements¶
The following minimum privileges and roles are required to view results for custom budgets:
ADMIN 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.
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();