| Column Name | Column Data Type |
|---|
account_id Required Input Column
The account ID of the user. It's a 12-digit number. | 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
Retrieves how often the budget went into an ALARM state for the specified time period. | 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.
|
budget_type
The type of a budget. It must be one of the following types: COST, USAGE, RI_UTILIZATION, RI_COVERAGE, SAVINGS_PLANS_UTILIZATION, or SAVINGS_PLANS_COVERAGE. | VARCHAR |
budgeted_and_actual_amounts_list
A list of amounts of cost or usage that you created budgets for, which are compared to your actual costs or usage. | STRUCT(
"budgeted_amount" STRUCT(
"amount" VARCHAR,
"unit" VARCHAR
),
"actual_amount" STRUCT(
"amount" VARCHAR,
"unit" VARCHAR
),
"time_period" STRUCT(
"start" TIMESTAMP_S,
"end" TIMESTAMP_S
)
)[] |
Show child fields- budgeted_and_actual_amounts_list[]
Show child fields- budgeted_and_actual_amounts_list[].actual_amount
Your actual costs or usage for a budget period. Show child fields- budgeted_and_actual_amounts_list[].actual_amount.amount
The cost or usage amount that's associated with a budget forecast, actual spend, or budget threshold. - budgeted_and_actual_amounts_list[].actual_amount.unit
The unit of measurement that's used for the budget forecast, actual spend, or budget threshold.
- budgeted_and_actual_amounts_list[].budgeted_amount
The amount of cost or usage that you created the budget for. Show child fields- budgeted_and_actual_amounts_list[].budgeted_amount.amount
The cost or usage amount that's associated with a budget forecast, actual spend, or budget threshold. - budgeted_and_actual_amounts_list[].budgeted_amount.unit
The unit of measurement that's used for the budget forecast, actual spend, or budget threshold.
- budgeted_and_actual_amounts_list[].time_period
The time period that's covered by this budget comparison. Show child fields- budgeted_and_actual_amounts_list[].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. - budgeted_and_actual_amounts_list[].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.
|
cost_filters
The history of the cost filters for a budget during the specified time period. | MAP(VARCHAR, VARCHAR[]) |
cost_types
The history of the cost types for a budget during the specified time period. | STRUCT(
"include_tax" BOOLEAN,
"include_subscription" BOOLEAN,
"use_blended" BOOLEAN,
"include_refund" BOOLEAN,
"include_credit" BOOLEAN,
"include_upfront" BOOLEAN,
"include_recurring" BOOLEAN,
"include_other_subscription" BOOLEAN,
"include_support" BOOLEAN,
"include_discount" BOOLEAN,
"use_amortized" BOOLEAN
) |
Show child fields- cost_types.include_credit
Specifies whether a budget includes credits. The default value is true. - cost_types.include_discount
Specifies whether a budget includes discounts. The default value is true. - cost_types.include_other_subscription
Specifies whether a budget includes non-RI subscription costs. The default value is true. - cost_types.include_recurring
Specifies whether a budget includes recurring fees such as monthly RI fees. The default value is true. - cost_types.include_refund
Specifies whether a budget includes refunds. The default value is true. - cost_types.include_subscription
Specifies whether a budget includes subscriptions. The default value is true. - cost_types.include_support
Specifies whether a budget includes support subscription fees. The default value is true. - cost_types.include_tax
Specifies whether a budget includes taxes. The default value is true. - cost_types.include_upfront
Specifies whether a budget includes upfront RI costs. The default value is true. - cost_types.use_amortized
Specifies whether a budget uses the amortized rate. The default value is false. - cost_types.use_blended
Specifies whether a budget uses a blended rate. The default value is false.
|
time_unit
The time unit of the budget, such as MONTHLY or QUARTERLY. | VARCHAR |