Skip to main content

budget_actions

Creates, updates, deletes, gets or lists a budget_actions resource.

Overview

Namebudget_actions
TypeResource
Idaws.budgets.budget_actions

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
account_idstringThe account ID of the user. It's a 12-digit number. (pattern: <code>\d{12}</code>)
actionobjectA budget action resource.
budget_namestringA string that represents the budget name. The ":" and "" characters, and the "/action/" substring, aren't allowed. Budget names are validated for content. Names that contain phone numbers, URLs, or email addresses combined with certain terms may be rejected. (pattern: <code>^(?![^:\]/action/|(?i).<script>.</script>.)[^:\]+$</code>)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_budget_actionselectregionDescribes a budget action detail.
create_budget_actioninsertregion, AccountId, BudgetName, NotificationType, ActionType, ActionThreshold, Definition, ExecutionRoleArn, ApprovalModel, SubscribersCreates a budget action.
update_budget_actionupdateregion, AccountId, BudgetName, ActionIdUpdates a budget action.
delete_budget_actiondeleteregionDeletes a budget action.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)

SELECT examples

Describes a budget action detail.

SELECT
account_id,
action,
budget_name
FROM aws.budgets.budget_actions
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a budget action.

INSERT INTO aws.budgets.budget_actions (
AccountId,
BudgetName,
NotificationType,
ActionType,
ActionThreshold,
Definition,
ExecutionRoleArn,
ApprovalModel,
Subscribers,
ResourceTags,
region
)
SELECT
'{{ AccountId }}' /* required */,
'{{ BudgetName }}' /* required */,
'{{ NotificationType }}' /* required */,
'{{ ActionType }}' /* required */,
'{{ ActionThreshold }}' /* required */,
'{{ Definition }}' /* required */,
'{{ ExecutionRoleArn }}' /* required */,
'{{ ApprovalModel }}' /* required */,
'{{ Subscribers }}' /* required */,
'{{ ResourceTags }}',
'{{ region }}'
RETURNING
account_id,
action_id,
budget_name
;

UPDATE examples

Updates a budget action.

UPDATE aws.budgets.budget_actions
SET
AccountId = '{{ AccountId }}',
BudgetName = '{{ BudgetName }}',
ActionId = '{{ ActionId }}',
NotificationType = '{{ NotificationType }}',
ActionThreshold = '{{ ActionThreshold }}',
Definition = '{{ Definition }}',
ExecutionRoleArn = '{{ ExecutionRoleArn }}',
ApprovalModel = '{{ ApprovalModel }}',
Subscribers = '{{ Subscribers }}'
WHERE
region = '{{ region }}' --required
AND AccountId = '{{ AccountId }}' --required
AND BudgetName = '{{ BudgetName }}' --required
AND ActionId = '{{ ActionId }}' --required
RETURNING
account_id,
budget_name,
new_action,
old_action;

DELETE examples

Deletes a budget action.

DELETE FROM aws.budgets.budget_actions
WHERE region = '{{ region }}' --required
;