<budget_name>!REMOVE_RESOURCE¶
Remove an object from a custom budget. The object must be removed by reference.
Syntax¶
<budget_name>!REMOVE_RESOURCE( { '<object_reference>' | <reference_statement> } )
Arguments¶
'object_reference'
The serialized string representation that resolves to an object. This string is the output of the SYSTEM$REFERENCE function.
reference_statement
A SYSTEM$REFERENCE statement that creates a reference for the object to be removed from the budget.
Returns¶
Successfully removed resource from resource group
Access control requirements¶
The following minimum privileges and roles are required to call this method on a custom budget:
ADMIN instance role for the budget instance.
USAGE privilege on the database and schema that contains the budget instance.
USAGE privilege on the database and schema that contain the object (for schema objects).
APPLYBUDGET privilege on the object being removed.
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¶
Remove table t1
from budget my_budget
in schema budget_db.budget_schema
by using
an identifier for a reference:
CALL budget_db.budget_schema.my_budget!REMOVE_RESOURCE(
'ENT_REF_TABLE_5862683050074_5AEB8D58FB3ACF249F2E35F365A9357C46BB00D7');
Remove table t1
from budget my_budget
in schema budget_db.budget_schema
by using
a SYSTEM$REFERENCE statement:
CALL budget_db.budget_schema.my_budget!REMOVE_RESOURCE(
SELECT SYSTEM$REFERENCE('TABLE', 't1', 'SESSION', 'APPLYBUDGET')
Error messages¶
For a list of common error messages and their causes and solutions, see You can’t add or remove objects from a custom budget.