Skip to content

aws.budgets.describe_budget_action_histories

Example SQL Queries

SELECT * FROM
aws.budgets.describe_budget_action_histories
WHERE
"account_id" = 'VALUE'
AND "budget_name" = 'VALUE'
AND "action_id" = 'VALUE';

Description

Describes a budget action history detail.

Table Definition

Column NameColumn Data Type
account_id Required Input Column

The account ID of the user. It's a 12-digit number.

VARCHAR
action_id Required Input Column

A system-generated universally unique identifier (UUID) for the action.

VARCHAR
budget_name Required Input Column

A string that represents the budget name. The ":" and "\" characters, and the "/action/" substring, aren't allowed.

VARCHAR
time_period Input Column

The period of time that's covered by a budget. The period has a start date and an end date. The start date must come before the end date. There are no restrictions on the end date.

STRUCT(
"start" TIMESTAMP_S,
"end" TIMESTAMP_S
)
Show child fields
time_period.end

The end date for a budget. If you didn't specify an end date, Amazon Web Services set your end date to 06/15/87 00:00 UTC. The defaults are the same for the Billing and Cost Management console and the API.

After the end date, Amazon Web Services deletes the budget and all the associated notifications and subscribers. You can change your end date with the UpdateBudget operation.

time_period.start

The start date for a budget. If you created your budget and didn't specify a start date, Amazon Web Services defaults to the start of your chosen time period (DAILY, MONTHLY, QUARTERLY, or ANNUALLY). For example, if you created your budget on January 24, 2018, chose DAILY, and didn't set a start date, Amazon Web Services set your start date to 01/24/18 00:00 UTC. If you chose MONTHLY, Amazon Web Services set your start date to 01/01/18 00:00 UTC. The defaults are the same for the Billing and Cost Management console and the API.

You can change your start date with the UpdateBudget operation.

_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

action_history_details

The description of the details for the event.

STRUCT(
"message" VARCHAR,
"action" STRUCT(
"action_id" VARCHAR,
"budget_name" VARCHAR,
"notification_type" VARCHAR,
"action_type" VARCHAR,
"action_threshold" STRUCT(
"action_threshold_value" DOUBLE,
"action_threshold_type" VARCHAR
),
"definition" STRUCT(
"iam_action_definition" STRUCT(
"policy_arn" VARCHAR,
"roles" VARCHAR[],
"groups" VARCHAR[],
"users" VARCHAR[]
),
"scp_action_definition" STRUCT(
"policy_id" VARCHAR,
"target_ids" VARCHAR[]
),
"ssm_action_definition" STRUCT(
"action_sub_type" VARCHAR,
"region" VARCHAR,
"instance_ids" VARCHAR[]
)
),
"execution_role_arn" VARCHAR,
"approval_model" VARCHAR,
"status" VARCHAR,
"subscribers" STRUCT(
"subscription_type" VARCHAR,
"address" VARCHAR
)[]
)
)
Show child fields
action_history_details.action

The budget action resource.

Show child fields
action_history_details.action.action_id

A system-generated universally unique identifier (UUID) for the action.

action_history_details.action.action_threshold

The trigger threshold of the action.

Show child fields
action_history_details.action.action_threshold.action_threshold_type

The type of threshold for a notification.

action_history_details.action.action_threshold.action_threshold_value

The threshold of a notification.

action_history_details.action.action_type

The type of action. This defines the type of tasks that can be carried out by this action. This field also determines the format for definition.

action_history_details.action.approval_model

This specifies if the action needs manual or automatic approval.

action_history_details.action.budget_name

A string that represents the budget name. The ":" and "\" characters, and the "/action/" substring, aren't allowed.

action_history_details.action.definition

Where you specify all of the type-specific parameters.

Show child fields
action_history_details.action.definition.iam_action_definition

The Identity and Access Management (IAM) action definition details.

Show child fields
action_history_details.action.definition.iam_action_definition.groups[]
action_history_details.action.definition.iam_action_definition.policy_arn

The Amazon Resource Name (ARN) of the policy to be attached.

action_history_details.action.definition.iam_action_definition.roles[]
action_history_details.action.definition.iam_action_definition.users[]
action_history_details.action.definition.scp_action_definition

The service control policies (SCPs) action definition details.

Show child fields
action_history_details.action.definition.scp_action_definition.policy_id

The policy ID attached.

action_history_details.action.definition.scp_action_definition.target_ids[]
action_history_details.action.definition.ssm_action_definition

The Amazon Web Services Systems Manager (SSM) action definition details.

Show child fields
action_history_details.action.definition.ssm_action_definition.action_sub_type

The action subType.

action_history_details.action.definition.ssm_action_definition.instance_ids[]
action_history_details.action.definition.ssm_action_definition.region

The Region to run the SSM document.

action_history_details.action.execution_role_arn

The role passed for action execution and reversion. Roles and actions must be in the same account.

action_history_details.action.notification_type

The type of a notification. It must be ACTUAL or FORECASTED.

action_history_details.action.status

The status of the action.

action_history_details.action.subscribers[]
Show child fields
action_history_details.action.subscribers[].address

The address that Amazon Web Services sends budget notifications to, either an SNS topic or an email.

When you create a subscriber, the value of Address can't contain line breaks.

action_history_details.action.subscribers[].subscription_type

The type of notification that Amazon Web Services sends to a subscriber.

action_history_details.message

A generic string.

event_type

This distinguishes between whether the events are triggered by the user or are generated by the system.

VARCHAR
status

The status of action at the time of the event.

VARCHAR
timestamp

A generic time stamp. In Java, it's transformed to a Date object.

TIMESTAMP_S