# Data Exports table dictionary
Data Exports provides several tables that you can query when creating an export.
The following topics describe the schema for each available table with definitions for each column present.
**Topics**
+ [Cost and Usage Report (CUR) 2.0](table-dictionary-cur2.md)
+ [Cost optimization recommendations (from Cost Optimization Hub)](table-dictionary-cor.md)
+ [FOCUS 1.2 with AWS columns](table-dictionary-focus-1-2-aws.md)
+ [FOCUS 1.0 with AWS columns](table-dictionary-focus-1-0-aws.md)
+ [Cost and usage dashboard](table-dictionary-cur-dashboard.md)
+ [Carbon emissions](table-dictionary-carbon-emissions.md)
# Cost and Usage Report (CUR) 2.0
The CUR 2.0 table provides the same information as Cost and Usage Reports (CUR) with a few improvements.
Cost and Usage Reports 2.0 provides the following improvements over Cost and Usage Reports:
+ **Consistent schema**: CUR 2.0 contains a fixed set of columns, whereas the columns included for CUR can vary monthly depending on your usage of AWS services, cost categories, and resource tags.
+ **Nested data**: CUR 2.0 reduces data sparsity by collapsing certain columns from CUR into individual columns with key-value pairs of the collapsed columns. The nested keys can optionally be queried in Data Exports as separate columns to match the original CUR schema and data.
+ **Additional columns**: CUR 2.0 contains additional columns: **bill\$1payer\$1account\$1name**, **line\$1item\$1usage\$1account\$1name**, **capacity\$1reservation\$1capacity\$1reservation\$1arn**, **capacity\$1reservation\$1capacity\$1reservation\$1status** and **capacity\$1reservation\$1capacity\$1reservation\$1type**.
The SQL table name for CUR 2.0 is `COST_AND_USAGE_REPORT`.
## Table configurations
Table configurations are user-controlled properties that a user can set to change the data or schema of a table before it's queried in Data Exports. The table configurations are saved as a JSON statement and are either specified through user input in the AWS SDK/CLI or user selections in the console.
CUR 2.0 has the following table configurations:
****
| Configuration name | Description | Valid values |
| --- | --- | --- |
| TIME\$1GRANULARITY | This configuration changes the cost and usage line items in the CUR 2.0 table to have different time granularities. For example, selecting "HOURLY" will make all line items represent a single hour of usage. | HOURLY, DAILY, MONTHLY |
| INCLUDE\$1RESOURCES | This configuration changes the cost and usage line items in the CUR 2.0 table to have resource-level granularity and adds the "line\$1item\$1resource\$1id" column to the table schema. Enabling this configuration causes the CUR 2.0 table to have a line item for each resource that incurred usage for a given service, instead of showing combined total usage for that service. Enabling this configuration can greatly increase the number of rows, and also the file size of your export. | TRUE, FALSE |
| INCLUDE\$1SPLIT\$1COST\$1ALLOCATION\$1DATA | This configuration adds split cost allocation data and columns (split\$1line\$1item\$1\$1) to the CUR 2.0 table. This data indicates how the usage of certain AWS resources can be allocated to different business units or teams. Enabling this configuration can add additional rows and columns which show how an EC2 instance can be allocated to different containers running in that instance. For more information, see [Understanding split cost allocation data](https://docs.aws.amazon.com/cur/latest/userguide/split-cost-allocation-data.html). | TRUE, FALSE |
| INCLUDE\$1CAPACITY\$1RESERVATION\$1DATA | **Note:** This configuration only adds data in the new columns starting November 1, 2025. Enabling this configuration changes the cost and usage line items in the CUR 2.0 table to have resource-level granularity when an instance usage is split across multiple capacity reservations or used partially in a capacity reservationin an hour. This also adds 3 new columns to the table schema, which show how an EC2 instance is launched in a capacity reservation. | TRUE, FALSE |
| INCLUDE\$1IAM\$1PRINCIPAL\$1DATA | **Note:** This configuration only adds data in the new columns starting April 8, 2026. Enabling this configuration causes the CUR 2.0 table to include caller identity (IAM principal) allocation data for Amazon Bedrock model inference costs. This adds the line\$1item\$1iam\$1principal column to the table schema, which contains the AWS IAM principal ARN of the caller making Bedrock inference requests. When IAM principal tags are activated as cost allocation tags, those tags also appear in the tags column with the iamPrincipal/ prefix (e.g., iamPrincipal/department, iamPrincipal/cost-center). Enabling this configuration can increase the number of CUR rows and file size. | TRUE, FALSE |
| INCLUDE\$1MANUAL\$1DISCOUNT\$1COMPATIBILITY | **Note:** This configuration only applies to AWS customers who have onboarded to the Discount Automation program where discounts are computed automatically. This configuration changes the discounts in the CUR 2.0 table to appear as when they were added "manually" to the CUR, usually as separate line items, and removes two columns from the schema ("discount" and "total\$1discount"). | TRUE, FALSE |
## AWS Organizations support
The CUR 2.0 table inherits the settings you made in the consolidated billing feature in AWS Organizations. When consolidated billing is enabled, there are different behaviors for management and member accounts. If you’re using a management account, your CUR 2.0 table includes cost and usage data for the management account and all member accounts in your organization. If you’re using a member account, your CUR 2.0 table only includes cost and usage data for that member account.
After joining an organization, a member account can only export data for the time that the account has been a member of the organization. For example, let's say that a member account leaves organization A and joins organization B on the 15th of the month. Then, the member account creates an export. Because the member account created an export after joining organization B, the member account’s export of CUR 2.0 for the month only includes cost and usage data for the time that the account has been a member of organization B.
After a member account joins a new organization, the member account's cost and usage data is recorded in the new organization’s exports. This is the same outcome for a management account that converts to a member account and joins a new organization.
When a member account leaves an organization or converts to a standalone account, the member account can still access previous exports as long as they have permissions to the Amazon S3 bucket where the previous exports are stored.
For more information, see [Consolidated billing for AWS Organizations](https://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/consolidated-billing.html) in the *AWS Billing User Guide*.
## CUR 2.0 column groups
There are 125 possible columns in the CUR 2.0 table, grouped as follows:
+ **Bill:** Data about your bill for the billing period.
+ **Cost category:** Data about cost categories that apply to the line item.
+ **Capacity reservation:** Data about capacity reservation that applies to the line item.
+ **Discount:** Data about any discounts you are receiving.
+ **Identity:** Data to identify a line item.
+ **Line item:** Data about cost, usage, type of usage, pricing rates, product name, and more.
+ **Pricing:** Data about the pricing for a line item.
+ **Product:** Data about the product that is being charged in the line item.
+ **Reservation:** Data about a reservation that applies to the line item.
+ **Resource tags:** Data about resource tags that apply to the line item.
+ **Savings plan:** Data about savings plans that apply to the line item.
+ **Split line item:** Data about split cost allocation for another line item.
+ **Capacity Reservation:** Data about capacity reservation that applies to the line item.
+ **Tags:** Data about user, account, cost category and resource tags.
# Bill columns
Bill columns contain data about your bill for the billing period.
****
| Column name | Description | Data type |
| --- | --- | --- |
| bill\$1bill\$1type | The type of bill that this report covers. There are three bill types: [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur2-bill.html) | string |
| bill\$1billing\$1entity | Helps you identify whether your invoices or transactions are for AWS Marketplace or for purchases of other AWS services. | string |
| bill\$1billing\$1period\$1end\$1date | The end date of the billing period that is covered by this report, in UTC. The format is `YYYY-MM-DDTHH:mm:ssZ`. | timestamp |
| bill\$1billing\$1period\$1start\$1date | The start date of the billing period that is covered by this report, in UTC. The format is `YYYY-MM-DDTHH:mm:ssZ`. | timestamp |
| bill\$1invoice\$1id | The ID associated with a specific line item. Until the report is final, the `InvoiceId` is blank. | string |
| bill\$1invoicing\$1entity | The AWS entity that issues the invoice. | string |
| bill\$1payer\$1account\$1id | The account ID of the paying account. For an organization in AWS Organizations, this is the account ID of the management account. | string |
| bill\$1payer\$1account\$1name | The account name of the paying account. For an organization in AWS Organizations, this is the name of the management account. | string |
# Cost category columns
Cost category columns contain data about cost categories that apply to the line item. Note that you don’t need to select this column if you selected the Tags column because resource tags are also included under the Tags column.
****
| Column name | Description | Data type |
| --- | --- | --- |
| cost\$1category | A map column containing key-value pairs of the cost categories and their values for a given line item. These keys and values are populated based on the categorization rules you create in the cost categories feature. A cost category key only appears in the map column if it has a value that applies to the specific line item. The keys of this column can be queried as individual columns using the dot operator. For more information, see [Data query](https://docs.aws.amazon.com/cur/latest/userguide/dataexports-data-query.html). | map |
# Discount columns
Discount columns contain data about any discounts you are receiving.
****
| Column name | Description | Data type |
| --- | --- | --- |
| discount | **Table configuration:** Removed by: INCLUDE MANUAL DISCOUNT COMPATIBILITY A "struct" column containing key-value pairs of any specific discounts that apply to this line item. The keys correspond to a discount type and the values correspond to either the discount value or other information. The values in this column are either data type "numeric" or "string" depending on the specific key. The keys of this column can be queried as individual columns by using the dot operator. For more information, see [Data query](https://docs.aws.amazon.com/cur/latest/userguide/dataexports-data-query.html). This column is not available when "Manual discount compatibility" is enabled. When it's enabled, discounts are populated as separate line items and not in this column. | map |
| discount\$1bundled\$1discount | The bundled discount applied to the line item. A bundled discount is a usage-based discount that provides free or discounted usage of a service or feature based on the usage of another service or feature. As of August 2025, bundled discounts are applied using an "Owner-first approach" where discounts are first applied to the account that generates the source usage. Within the source account, discounts are applied based on the following sequence: [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur2-discount.html) Any remaining discounts are distributed across other accounts in the Consolidated Billing Family (CBF) based on the following sequence: [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur2-discount.html) Examples of bundled discounts include: [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur2-discount.html) | double |
| discount\$1total\$1discount | **Table configuration:** Removed by: `INCLUDE MANUAL DISCOUNT COMPATIBILITY` The sum of all the discount columns for the corresponding line item. This column is not available when "Manual discount compatibility" is enabled. When it's enabled, discounts are populated as separate line items and not in this column. | double |
# Identity columns
Identity columns contain data to identify a line item.
****
| Column name | Description | Data type |
| --- | --- | --- |
| identity\$1line\$1item\$1id | This field is generated for each line item and is unique in a given partition. This does not guarantee that the field will be unique across an entire delivery (that is, all partitions in an update) of the AWS CUR. The line item ID isn't consistent between different Cost and Usage Reports and can't be used to identify the same line item across different reports. | string |
| identity\$1time\$1interval | The time interval that this line item applies to, in the following format: `YYYY-MM-DDTHH:mm:ssZ/YYYY-MM-DDTHH:mm:ssZ`. The time interval is in UTC and can either be daily or hourly, depending on the report granularity. | string |
# Line item columns
Line item columns contain data about cost, usage, type of usage, pricing rates, product name, and more.
****
| Column name | Description | Data type |
| --- | --- | --- |
| line\$1item\$1usage\$1account\$1name | The name of the account that used this line item. For organizations, this can be either the management account or a member account. You can use this field to track costs or usage by account. | string |
| line\$1item\$1availability\$1zone | The Availability Zone that hosts this line item. For example, us-east-1a or us-east-1b. | string |
| line\$1item\$1blended\$1cost | The `BlendedRate` multiplied by the `UsageAmount`. **BlendedCost** is blank for line items that have a **LineItemType** of **Discount**. Discounts are calculated using only the unblended cost of a member account, aggregated by member account and SKU. As a result, **BlendedCost** is not available for discounts. | double |
| line\$1item\$1blended\$1rate | The `BlendedRate` is the average cost incurred for each SKU across an organization. For example, the Amazon S3 blended rates are the total cost of storage divided by the amount of data stored per month. For accounts with RIs, the blended rates are calculated as the average costs of the RIs and the On-Demand Instances. Blended rates are calculated at the management account level, and used to allocate costs to each member account. For more information, see [Blended Rates and Costs](https://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/con-bill-blended-rates.html#Blended_CB) in the *AWS Billing User Guide*. | string |
| line\$1item\$1currency\$1code | The currency that this line item is shown in. All AWS customers are billed in US dollars by default. To change your billing currency, see [Changing which currency you use to pay your bill](https://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/manage-account-payment.html#manage-account-payment-change-currency) in the *AWS Billing User Guide*. | string |
| line\$1item\$1iam\$1principal | The IAM ARN of the principal that performed the Amazon Bedrock model inference. This column is populated when you enable IAM principal data in your CUR 2.0 data export. Currently supported for Amazon Bedrock only. | string |
| line\$1item\$1legal\$1entity | The Seller of Record of a specific product or service. In most cases, the invoicing entity and legal entity are the same. The values might differ for third-party AWS Marketplace transactions. Possible values include: [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur2-line-item.html) | string |
| line\$1item\$1line\$1item\$1description | The description of the line item type. For example, the description of a usage line item summarizes the type of usage incurred during a specific time period. For size-flexible RIs, the description corresponds to the RI the benefit was applied to. For example, if a line item corresponds to a `t2.micro` and a `t2.small` RI was applied to the usage, the **line\$1item\$1line\$1item\$1description** displays `t2.small`. The description for a usage line item with an RI discount contains the pricing plan covered by the line item. | string |
| line\$1item\$1line\$1item\$1type | The type of charge covered by this line item. The possible types are as follows: [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur2-line-item.html) | string |
| line\$1item\$1net\$1unblended\$1cost | The actual after-discount cost that you're paying for the line item. This column is only included in your report when your account has a discount in the applicable billing period. | double |
| line\$1item\$1net\$1unblended\$1rate | The actual after-discount rate that you're paying for the line item. This column is only included in your report when your account has a discount in the applicable billing period. | string |
| line\$1item\$1normalization\$1factor | As long as the instance has shared tenancy, AWS can apply all Regional Linux or Unix Amazon EC2 and Amazon RDS RI discounts to all instance sizes in an instance family and AWS Region. This also applies to RI discounts for member accounts in an organization. All new and existing Amazon EC2 and Amazon RDS size-flexible RIs are sized according to a normalization factor, based on the instance size. | double |
| line\$1item\$1normalized\$1usage\$1amount | The amount of usage that you incurred, in normalized units, for size-flexible RIs. The **NormalizedUsageAmount** is equal to **UsageAmount** multiplied by **NormalizationFactor**. | double |
| line\$1item\$1operation | The specific AWS operation covered by this line item. This describes the specific usage of the line item. For example, a value of RunInstances indicates the operation of an Amazon EC2 instance. | string |
| line\$1item\$1product\$1code | The code of the product measured. For example, Amazon EC2 is the product code for Amazon Elastic Compute Cloud. | string |
| line\$1item\$1resource\$1id | **Table configuration:** Added by: INCLUDE RESOURCES (Optional) If you chose to include individual resource IDs in your report, this column contains the ID of the resource that you provisioned. For example, an Amazon S3 storage bucket, an Amazon EC2 compute instance, or an Amazon RDS database can each have a resource ID. This field is blank for usage types that aren't associated with an instantiated host, such as data transfers and API requests, and line item types such as discounts, credits, and taxes. | string |
| line\$1item\$1tax\$1type | The type of tax that AWS applied to this line item. | string |
| line\$1item\$1unblended\$1cost | The UnblendedCost is the UnblendedRate multiplied by the UsageAmount. | double |
| line\$1item\$1unblended\$1rate | In consolidated billing for accounts using AWS Organizations, the unblended rate is the rate associated with an individual account's service usage. For Amazon EC2 and Amazon RDS line items that have an RI discount applied to them, the `UnblendedRate` is `0`. Line items with an RI discount have a `LineItemType` of `DiscountedUsage`. | string |
| line\$1item\$1usage\$1account\$1id | The account ID of the account that used this line item. For organizations, this can be either the management account or a member account. You can use this field to track costs or usage by account. | string |
| line\$1item\$1usage\$1amount | The amount of usage that you incurred during the specified time period. For size-flexible Reserved Instances, use the **reservation/TotalReservedUnits** column instead. Certain subscription charges will have a **UsageAmount** of `0`. | double |
| line\$1item\$1usage\$1end\$1date | The end date and time for the corresponding line item in UTC, exclusive. The format is YYYY-MM-DDTHH:mm:ssZ. | timestamp |
| line\$1item\$1usage\$1start\$1date | The start date and time for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ. | timestamp |
| line\$1item\$1usage\$1type | The usage details of the line item. For example, USW2-BoxUsage:m2.2xlarge describes an M2 High Memory Double Extra Large instance in the US West (Oregon) Region. | string |
| line\$1item\$1user\$1identifier | The Identity Access Management (IAM) Identity Center identifier of a workforce user. The monthly flat-rate subscription and on-demand charges are calculated for the user identified by this identifier. | string |
# Pricing columns
Pricing columns contain data about the pricing for a line item.
****
| Column name | Description | Data type |
| --- | --- | --- |
| pricing\$1currency | The currency that the pricing data is shown in. | string |
| pricing\$1lease\$1contract\$1length | The length of time that your RI is reserved for. | string |
| pricing\$1offering\$1class | The offering class of the Reserved Instance. | string |
| pricing\$1public\$1on\$1demand\$1cost | The total cost for the line item based on public On-Demand Instance rates. If you have SKUs with multiple On-Demand public costs, the equivalent cost for the highest tier is displayed. For example, services offering free-tiers or tiered pricing. | double |
| pricing\$1public\$1on\$1demand\$1rate | The public On-Demand Instance rate in this billing period for the specific line item of usage. If you have SKUs with multiple On-Demand public rates, the equivalent rate for the highest tier is displayed. For example, services offering free-tiers or tiered pricing. | string |
| pricing\$1purchase\$1option | How you chose to pay for this line item. Valid values are All Upfront, Partial Upfront, and No Upfront. | string |
| pricing\$1rate\$1code | A unique code for a product/offer/pricing-tier combination. The product and term combinations can have multiple price dimensions, such as a free tier, low-use tier, and high-use tier. | string |
| pricing\$1rate\$1id | The ID of the rate for a line item. | string |
| pricing\$1term | Whether your AWS usage is Reserved or On-Demand. | string |
| pricing\$1unit | The pricing unit AWS used to calculate your usage cost. For example, the pricing unit for Amazon EC2 instance usage is in hours. | string |
# Product columns
Product columns contain data about the product that is being charged in the line item.
****
| Column name | Description | Data type |
| --- | --- | --- |
| product | A map column containing key-value pairs of multiple product attributes and their values for a given line item. A product attribute only appears in the map column if it has a value that applies to the specific line item. Any product column that appeared in legacy CUR, but is not part of the CUR 2.0 static schema, appears in this map column. The keys of this column can be queried as individual columns by using the dot operator. For more information, see [Data query](https://docs.aws.amazon.com/cur/latest/userguide/dataexports-data-query.html). | map |
| product\$1comment | A comment regarding the product. | string |
| product\$1fee\$1code | The code that refers to the fee. | string |
| product\$1fee\$1description | The description for the product fee. | string |
| product\$1from\$1location | Describes the location where the usage originated from. | string |
| product\$1from\$1location\$1type | Describes the location type where the usage originated from. | string |
| product\$1from\$1region\$1code | Describes the source Region code for the AWS service. | string |
| product\$1instanceSKU | The SKU of the product instance | string |
| product\$1instance\$1family | Describes your Amazon EC2 instance family. Amazon EC2 provides you with a large number of options across 10 different instance types, each with one or more size options, organized into distinct instance families optimized for different types of applications. | string |
| product\$1instance\$1type | Describes the instance type, size, and family, which define the CPU, networking, and storage capacity of your instance. | string |
| product\$1location | Describes the Region that your Amazon S3 bucket resides in. | string |
| product\$1location\$1type | Describes the endpoint of your task. | string |
| product\$1operation | Describes the specific AWS operation that this line item covers. | string |
| product\$1pricing\$1unit | The smallest billing unit for an AWS service. For example, 0.01c per API call. | string |
| product\$1product\$1family | The category for the type of product. | string |
| product\$1region\$1code | A Region is a physical location around the world where data centers are clustered. AWS calls each group of logical data centers an Availability Zone (AZ). Each AWS Region consists of multiple, isolated, and physically separate AZs within a geographical area. The Region code attribute has the same name as an AWS Region, and specifies where the AWS service is available. | string |
| product\$1sku | A unique code for a product. The SKU is created by combining the `ProductCode`, `UsageType`, and `Operation`. For size-flexible RIs, the SKU uses the instance that was used. For example, if you used a `t2.micro` instance and AWS applied a `t2.small` RI discount to the usage, the line item SKU is created with the `t2.micro`. | string |
| product\$1servicecode | This identifies the specific AWS service to the customer as a unique short abbreviation. | string |
| product\$1to \$1location\$1type | Describes the destination location of the service usage. | string |
| product\$1to\$1location | Describes the location usage destination. | string |
| product\$1to\$1region\$1code | Describes the source Region code for the AWS service. | string |
| product\$1usagetype | Describes the usage details of the line item. | string |
# Reservation columns
Reservation columns contain data about a reservation that applies to the line item.
****
| Column name | Description | Data type |
| --- | --- | --- |
| reservation\$1amortized\$1upfront\$1cost\$1for\$1usage | The initial upfront payment for all upfront RIs and partial upfront RIs amortized for usage time. The value is equal to: RIAmortizedUpfrontFeeForBillingPeriod \$1 The normalized usage amount for DiscountedUsage line items / The normalized usage amount for the RIFee. Because there are no upfront payments for no upfront RIs, the value for a no upfront RI is 0. We don't provide this value for Dedicated Host reservations at this time. The change will be made in a future update. | double |
| reservation\$1amortized\$1upfront\$1fee\$1for\$1billing\$1period | Describes how much of the upfront fee for this reservation is costing you for the billing period. The initial upfront payment for all upfront RIs and partial upfront RIs, amortized over this month. Because there are no upfront fees for no upfront RIs, the value for no upfront RIs is `0`. We don't provide this value for Dedicated Host reservations at this time. The change will be made in a future update. | double |
| reservation\$1availability\$1zone | The Availability Zone of the resource that is associated with this line item. | string |
| reservation\$1effective\$1cost | The sum of both the upfront and hourly rate of your RI, averaged into an effective hourly rate. EffectiveCost is calculated by taking the amortizedUpfrontCostForUsage and adding it to the recurringFeeForUsage. | double |
| reservation\$1end\$1time | The end date of the associated RI lease term. | string |
| reservation\$1modification\$1status | Shows whether the RI lease was modified or if it is unaltered. **Original:** The purchased RI was never modified. **System:** The purchased RI was modified using the console or API. **Manual:** The purchased RI was modified using AWS Support assistance. **ManualWithData:** The purchased RI was modified using AWS Support assistance, and AWS calculated estimates for the RI. | string |
| reservation\$1net\$1amortized\$1upfront\$1cost\$1for\$1usage | The initial upfront payment for All Upfront RIs and Partial Upfront RIs amortized for usage time, if applicable. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| reservation\$1net\$1amortized\$1upfront\$1fee\$1for\$1billing\$1period | The cost of the reservation's upfront fee for the billing period. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| reservation\$1net\$1effective\$1cost | The sum of both the upfront fee and the hourly rate of your RI, averaged into an effective hourly rate. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| reservation\$1net\$1recurring\$1fee\$1for\$1usage | The after-discount cost of the recurring usage fee. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| reservation\$1net\$1unused\$1amortized\$1upfront\$1fee\$1for\$1billing\$1period | The net unused amortized upfront fee for the billing period. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| reservation\$1net\$1unused\$1recurring\$1fee | The recurring fees associated with unused reservation hours for Partial Upfront and No Upfront RIs after discounts. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| reservation\$1net\$1upfront\$1value | The upfront value of the RI with discounts applied. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| reservation\$1normalized\$1units\$1per\$1reservation | The number of normalized units for each instance of a reservation subscription. | string |
| reservation\$1number\$1of\$1reservations | The number of reservations that are covered by this subscription. For example, one RI subscription might have four associated RI reservations. | string |
| reservation\$1recurring\$1fee\$1for\$1usage | The recurring fee amortized for usage time, for partial upfront RIs and no upfront RIs. The value is equal to: The unblended cost of the RIFee \$1 The sum of the normalized usage amount of Usage line items / The normalized usage amount of the RIFee for size flexible Reserved Instances. Because all upfront RIs don't have recurring fee payments greater than 0, the value for all upfront RIs is 0. | double |
| reservation\$1reservation\$1a\$1r\$1n | The Amazon Resource Name (ARN) of the RI that this line item benefited from. This is also called the "RI Lease ID". This is a unique identifier of this particular AWS Reserved Instance. The value string also contains the AWS service name and the Region where the RI was purchased. | string |
| reservation\$1start\$1time | The start date of the term of the associated Reserved Instance. | string |
| reservation\$1subscription\$1id | A unique identifier that maps a line item with the associated offer. We recommend you use the RI ARN as your identifier of an AWS Reserved Instance, but both can be used. | string |
| reservation\$1total\$1reserved\$1normalized\$1units | The total number of reserved normalized units for all instances for a reservation subscription. AWS computes total normalized units by multiplying the reservation/NormalizedUnitsPerReservation with reservation/NumberOfReservations. | string |
| reservation\$1total\$1reserved\$1units | TotalReservedUnits populates for both Fee and RIFee line items with distinct values. | string |
| reservation\$1units\$1per\$1reservation | UnitsPerReservation populates for both Fee and RIFee line items with distinct values. | string |
| reservation\$1unused\$1amortized\$1upfront\$1fee\$1for\$1billing\$1period | The amortized-upfront-fee-for-billing-period-column amortized portion of the initial upfront fee for all upfront RIs and partial upfront RIs. Because there are no upfront payments for no upfront RIs, the value for no upfront RIs is `0`. We don't provide this value for Dedicated Host reservations at this time. The change will be made in a future update. | double |
| reservation\$1unused\$1normalized\$1unit\$1quantity | The number of unused normalized units for a size-flexible Regional RI that you didn't use during this billing period. | double |
| reservation\$1unused\$1quantity | The number of RI hours that you didn't use during this billing period. | double |
| reservation\$1unused\$1recurring\$1fee | The recurring fees associated with your unused reservation hours for partial upfront and no upfront RIs. Because all upfront RIs don't have recurring fees greater than `0`, the value for All Upfront RIs is `0`. | double |
| reservation\$1upfront\$1value | The upfront price paid for your AWS Reserved Instance. For no upfront RIs, this value is `0`. | double |
# Resource tags columns
Resource tags columns contain data about resource tags that apply to the line item. Note that you don’t need to select this column if you selected the Tags column because resource tags are also included under the Tags column.
****
| Column name | Description | Data type |
| --- | --- | --- |
| resource\$1tags | A map column containing key-value pairs of resource tags and their values for a given line item. The values in this column are all of data type "string". Resource tag keys only appear in this column if they've been enabled as cost allocation tags in the Billing console. After being enabled, a particular key only appears in the map column if it has a value that applies to the specific line item. The keys of this column can be queried as individual columns using the dot operator. For more information, see [Data query](https://docs.aws.amazon.com/cur/latest/userguide/dataexports-data-query.html). | map |
# Savings plan columns
Saving Plan columns contain data about savings plans that apply to the line item.
****
| Column name | Description | Data type |
| --- | --- | --- |
| savings\$1plan\$1amortized\$1upfront\$1commitment\$1for\$1billing\$1period | The amount of upfront fee a Savings Plan subscription is costing you for the billing period. The initial upfront payment for **All Upfront Savings Plan** and **Partial Upfront Savings Plan** amortized over the current month. For **No Upfront Savings Plan**, the value is `0`. | double |
| savings\$1plan\$1end\$1time | The expiration date for the Savings Plan agreement. | string |
| savings\$1plan\$1instance\$1type\$1family | The instance family that is associated with the specified usage. | string |
| savings\$1plan\$1net\$1amortized\$1upfront\$1commitment\$1for\$1billing\$1period | The cost of a Savings Plan subscription upfront fee for the billing period. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| savings\$1plan\$1net\$1recurring\$1commitment\$1for\$1billing\$1period | The net unblended cost of the Savings Plan fee. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| savings\$1plan\$1net\$1savings\$1plan\$1effective\$1cost | The effective cost for Savings Plans, which is your usage divided by the fees. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| savings\$1plan\$1offering\$1type | Describes the type of Savings Plan purchased. | string |
| savings\$1plan\$1payment\$1option | The payment options available for your Savings Plan. | string |
| savings\$1plan\$1purchase\$1term | Describes the duration, or term, of the Savings Plan. | string |
| savings\$1plan\$1recurring\$1commitment\$1for\$1billing\$1period | The monthly recurring fee for your Savings Plan subscriptions. For example, the recurring monthly fee for a **Partial Upfront Savings Plan** or **No Upfront Savings Plan**. | double |
| savings\$1plan\$1region | The AWS Region (geographic area) that hosts your AWS services. You can use this field to analyze spend across a particular AWS Region. | string |
| savings\$1plan\$1savings\$1plan\$1a\$1r\$1n | The unique Savings Plan identifier. | string |
| savings\$1plan\$1savings\$1plan\$1effective\$1cost | The proportion of the Savings Plan monthly commitment amount (upfront and recurring) that is allocated to each usage line. | double |
| savings\$1plan\$1savings\$1plan\$1rate | The Savings Plan rate for the usage. | double |
| savings\$1plan\$1start\$1time | The start date of the Savings Plan agreement. | string |
| savings\$1plan\$1total\$1commitment\$1to\$1date | The total amortized upfront commitment and recurring commitment to date, for that hour. | double |
| savings\$1plan\$1used\$1commitment | The total dollar amount of the Savings Plan commitment used. (SavingsPlanRate multiplied by usage) | double |
# Split line item columns
Columns under the **split\$1line\$1item** header are fields that appear in Data Exports if you've opted in to the split cost allocation data feature. For more information, see [Understanding split cost allocation data](https://docs.aws.amazon.com/cur/latest/userguide/split-cost-allocation-data.html). The feature is limited to Amazon ECS (including Fargate), AWS Batch, and Amazon EKS only.
****
| Column name | Description | Data type |
| --- | --- | --- |
| split\$1line\$1item\$1actual\$1usage | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The usage for vCPU, memory, or accelerator resources (based on lineItem/UsageType) you incurred for the specified time period for the Amazon ECS task or Kubernetes pod. | double |
| split\$1line\$1item\$1net\$1split\$1cost | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The effective cost for Amazon ECS tasks or Kubernetes pods after all discounts have been applied. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| split\$1line\$1item\$1net\$1unused\$1cost | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The effective unused cost for Amazon ECS tasks or Kubernetes pods after all discounts have been applied. This column is included in your report only when your account has a discount in the applicable billing period. | double |
| split\$1line\$1item\$1parent\$1resource\$1id | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The resource ID of the parent EC2 instance associated with the Amazon ECS task or Amazon EKS pod (referenced in the lineItem/ResourceId column). The parent resource ID implies that the ECS task or Kubernetes pod workload for the specified time period ran on the parent EC2 instance. This applies only for Amazon ECS tasks or Kubernetes pods with EC2 launch type. | string |
| split\$1line\$1item\$1public\$1on\$1demand\$1split\$1cost | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The cost for vCPU or memory (based on lineItem/UsageType) allocated for the time period to the Amazon ECS task or Kubernetes pod based on public On-Demand Instance rates (referenced in the pricing/publicOnDemandRate column). | double |
| split\$1line\$1item\$1public\$1on\$1demand\$1unused\$1cost | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The unused cost for vCPU or memory (based on lineItem/UsageType) allocated for the time period to the Amazon ECS task or Kubernetes pod based on public On-Demand Instance rates. Unused costs are costs associated with resources (CPU or memory) on the EC2 instance (referenced in the splitLineItem/ParentResourceIdcolumn) that were not utilized for the specified time period. | double |
| split\$1line\$1item\$1reserved\$1usage | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The usage for vCPU, memory, or accelerator resources (based on lineItem/UsageType) that you configured for the specified time period for the Amazon ECS task or Kubernetes pod. | double |
| split\$1line\$1item\$1split\$1cost | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The cost for vCPU or memory (based on lineItem/UsageType) allocated for the time period to the Amazon ECS task or Kubernetes pod. This includes amortized costs if the EC2 instance (referenced in the splitLineItem/parentResourceId column) has upfront or partial upfront charges for reservations or Savings Plans. | double |
| split\$1line\$1item\$1split\$1usage | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The usage for vCPU or memory (based on lineItem/UsageType) allocated for the specified time period to the Amazon ECS task or Kubernetes pod. This is defined as the maximum usage of splitLineItem/ReservedUsage or splitLineItem/ActualUsage. | double |
| split\$1line\$1item\$1split\$1usage\$1ratio | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The ratio of vCPU, memory, or accelerator resources (based on lineItem/UsageType) allocated to the Amazon ECS task or Kubernetes pod compared to the overall CPU, memory, or accelerator resources available on the EC2 instance (referenced in the splitLineItem/ParentResourceId column). | double |
| split\$1line\$1item\$1unused\$1cost | **Table configuration:** Added by: INCLUDE SPLIT COST ALLOCATION DATA The unused cost for vCPU, memory, or accelerator resources (based on lineItem/UsageType) allocated for the time period to the Amazon ECS task or Kubernetes pod. Unused costs are costs associated with resources (CPU, memory, or accelerator resources) on the EC2 instance (referenced in the splitLineItem/ParentResourceId column) that were not utilized for the specified time period. This includes amortized costs if the EC2 instance (splitLineItem/parentResourceId) has upfront or partial upfront charges for reservations or Savings Plans. | double |
# Tags Column
Tags column contains data about user, account, cost category and resource tags that apply to the line item. If you select this column, you need not select Resource tags and Cost category columns in your CUR 2.0.
****
| Column name | Description | Data type |
| --- | --- | --- |
| tags | A map column containing key-value pairs of all tags and their values for a given line item. The values in this column are all of data type "string". Tag keys only appear in this column if they've been enabled as cost allocation tags in the Billing console. After being enabled, a particular key only appears in the map column if it has a value that applies to the specific line item. The keys of this column can be queried as individual columns using the dot operator. For more information, see [Data query](https://docs.aws.amazon.com/cur/latest/userguide/dataexports-data-query.html). | map |
## Understanding Tag Prefixes and Overlapping Tag Keys
When using cost allocation tags alongside other AWS tagging mechanisms, you may encounter situations where the same tag key (such as "department" or "aws:createdBy") appears across different tagging contexts. AWS automatically prefixes these tags to prevent conflicts and ensure accurate cost allocation.
**Tag Prefix Types**
AWS uses the following prefixes to distinguish between different tag sources:
1. resourceTags/ - Tags applied directly to AWS resources.
1. userAttribute/ - User attributes imported from IAM Identity Center.
1. accountTag/ - Tags applied at the AWS account level.
1. costCategory/ - Tags derived from AWS Cost Categories.
1. iamPrincipal/- Tags applied to [IAM principals](https://docs.aws.amazon.com/IAM/latest/UserGuide/id_roles.html#id_roles_additional-resources).
**Example: Overlapping Tag Keys**
Consider a scenario where multiple tagging mechanisms use the same tag keys. Here's how AWS handles them:
```
{
"resourceTags/department": "teamA",
"resourceTags/appName": "app1",
"userAttribute/Department": "teamB",
"accountTag/department": "teamC",
"accountTag/appName": "app3",
"costCategory/department": "teamD"
}
```
In this example:
+ The resource is tagged with department "teamA" at the resource level
+ The user who accessed the resource belongs to the "teamB" department in IAM Identity Center
+ The AWS account has an account-level tag indicating the "teamC" department
+ A cost category rule has assigned this cost to the "teamD" department
Each tag is preserved with its unique prefix, allowing you to analyze costs from multiple perspectives simultaneously. This enables you to:
+ Track which resources belong to which teams (`resourceTags/department`)
+ Understand which users from which departments are consuming resources (`userAttribute/Department`)
+ Allocate costs based on account ownership (`accountTag/department`)
+ Apply custom business logic through cost categories (`costCategory/department`)
# Capacity reservation columns
Capacity reservation columns contain data about capacity reservations that apply to the line item.
****
| Column name | Description | Data Type | Nullability | Properties |
| --- | --- | --- | --- | --- |
| capacity\$1reservation\$1capacity\$1reservation\$1arn | **Table configuration:** Added by: INCLUDE CAPACITY RESERVATION DATA The capacity reservation ARN represents the unique identifier of the capacity reservation | String | Nullable | This field is not null when a charge is related to a capacity reservation This field is not null when a charge represents the unused portion of a capacity reservation This field is null when a charge is not related to a capacity reservation |
| capacity\$1reservation\$1capacity\$1reservation\$1status | **Table configuration:** Added by: INCLUDE CAPACITY RESERVATION DATA Indicates whether the line item represents either the consumption of the capacity reservation identified in the capacity\$1reservation\$1capacity\$1reservation\$1arn column or when the capacity reservation is unused or when the capacity reservation is reserved. | String | Nullable | This field is null when capacity\$1reservation\$1capacity\$1reservation\$1arn is null This field is not null when capacity\$1reservation\$1capacity\$1reservation\$1arn is not null and line\$1item\$1line\$1item\$1type is **Usage** or **SavingsPlannedCoveredUsage** or **DiscountedUsage** This field contains one of the allowed values – Reserved, Used or Unused |
| capacity\$1reservation\$1capacity\$1reservation\$1type | **Table configuration:** Added by: INCLUDE CAPACITY RESERVATION DATA The capacity reservation type field represents the type of capacity reservation purchased. Currently, there are 2 types ODCR and EC2 Capacity Blocks for ML | String | Nullable | This field is null when capacity\$1reservation\$1capacity\$1reservation\$1arn is null This field is not null when capacity\$1reservation\$1capacity\$1reservation\$1arn is not null and line\$1item\$1line\$1item\$1type is **Usage** or **SavingsPlannedCoveredUsage** or **DiscountedUsage** This field contains one of the allowed values – ODCR or EC2 Capacity Blocks for ML |
# Cost optimization recommendations (from Cost Optimization Hub)
The cost optimization recommendations table contains your cost optimization recommendations from Cost Optimization Hub. Cost Optimization Hub recommendations are consolidated from AWS Compute Optimizer and consist of over 15 types of optimizations, such as resource rightsizing, idle resource deletion, Savings Plans, and Reserved Instances. For more detailed information, see [Cost Optimization Hub](https://docs.aws.amazon.com/cost-management/latest/userguide/cost-optimization-hub.html) in the *AWS Cost Management User Guide*.
The SQL table name for cost optimization recommendations is `COST_OPTIMIZATION_RECOMMENDATIONS`.
## Table configurations
Table configurations are user-controlled properties that a user can set to change the data or schema of a table before it's queried in Data Exports. The table configurations are saved as a JSON statement and are either specified through user input in the AWS SDK/CLI or user selections in the console.
Cost optimization recommendations has the following table configurations:
****
| Configuration name | Description | Valid values |
| --- | --- | --- |
| INCLUDE\$1ALL\$1RECOMMENDATIONS | When set to "FALSE", only the highest savings value recommendation is kept in the table from any set of recommendations that are incompatible with one another. For example, only "Terminate instance" is kept from a recommendation to terminate an instance and a recommendation to rightsize the same instance. When set to "TRUE", all recommendations are kept in the table. This is also known as **Group related recommendations** in the Cost Optimization Hub console. For more information, see [Grouping related recommendations](https://docs.aws.amazon.com/cost-management/latest/userguide/coh-group-recommendations.html) in the *AWS Cost Management User Guide*. | TRUE, FALSE |
| FILTER | This allows you to filter recommendations based on different recommendation attributes. Filters are applied to the table before the savings deduplication algorithm is applied. You can filter using the same parameters as in the Cost Optimization Hub console. For more information, see [Prioritizing your cost optimization opportunities](https://docs.aws.amazon.com/cost-management/latest/userguide/coh-prioritize-opportunities.html) in the *AWS Cost Management User Guide*. Filter statements are provided for this configuration using the same JSON structure that is used in the `filter` parameter in the Cost Optimization Hub `list-recommendations` API . It must be provided as a JSON string. For details, see the [`list-recommendations` structure](https://docs.aws.amazon.com/cli/latest/reference/cost-optimization-hub/list-recommendations.html#options). | Any JSON string that is valid for the Cost Optimization Hub list-recommendations API. |
## Service-linked role
A service-linked role for Data Exports is required to create an export of the cost optimization recommendations table. For information on how to create the service-linked role, see [Service-linked roles for Data Exports](https://docs.aws.amazon.com/cost-management/latest/userguide/data-exports-SLR.html) in the *AWS Cost Management User Guide*.
## AWS Organizations support
Cost Optimization Hub integrates with AWS Organizations to control whether a management account can see member account recommendations in Cost Optimization Hub. For more information, see [Getting started with Cost Optimization Hub](https://docs.aws.amazon.com/cost-management/latest/userguide/coh-getting-started.html) in the *AWS Cost Management User Guide*.
The cost optimization recommendations table for a given AWS account inherits the same AWS Organizations settings you configured for Cost Optimization Hub. This means the content of the cost optimization recommendations table matches the recommendations that appear in Cost Optimization Hub for each AWS account.
# Cost optimization recommendations columns
| Column name | Description | Data type | Null value allowed |
| --- | --- | --- | --- |
| account\$1id | The account ID that the recommendation is for. | string | No |
| account\$1name | The account name that the recommendation is for. | string | No |
| action\$1type | The type of action you can take by adopting the recommendation. | string | No |
| currency\$1code | The currency code used for the recommendation. | string | No |
| current\$1resource\$1details | The details for the resource in JSON string format. | string | Yes |
| current\$1resource\$1summary | A description of the current resource. | string | Yes |
| current\$1resource\$1type | The type of resource. | string | Yes |
| estimated\$1monthly\$1cost\$1after\$1discount | The estimated monthly cost of the current resource after discounts. For Reserved Instances and Savings Plans, it refers to the cost for eligible usage. | double | Yes |
| estimated\$1monthly\$1cost\$1before\$1discount | The estimated monthly cost of the current resource before discounts. For Reserved Instances and Savings Plans, it refers to the cost for eligible usage. | double | No |
| estimated\$1monthly\$1savings\$1after\$1discount | The estimated monthly savings amount for the recommendation after discounts. | double | Yes |
| estimated\$1monthly\$1savings\$1before\$1discount | The estimated monthly savings amount for the recommendation before discounts. | double | No |
| estimated\$1savings\$1percentage\$1after\$1discount | The estimated savings percentage after discounts relative to the total cost over the cost calculation lookback period. | double | Yes |
| estimated\$1savings\$1percentage\$1before\$1discount | The estimated savings percentage before discounts relative to the total cost over the cost calculation lookback period. | double | No |
| implementation\$1effort | The effort required to implement the recommendation. | string | No |
| last\$1refresh\$1timestamp | The time when the recommendation was last generated. | timestamp | No |
| recommendation\$1ID | The ID for the recommendation. | string | No |
| recommendation\$1lookback\$1period\$1in\$1days | The lookback period that's used to generate the recommendation. | integer | No |
| recommendation\$1source | The source of the recommendation. | string | No |
| recommended\$1resource\$1details | The details about the recommended resource in JSON string format. | string | Yes |
| recommended\$1resource\$1summary | A description of the recommended resource. | string | Yes |
| recommended\$1resource\$1type | The resource type of the recommendation. | string | Yes |
| region | The AWS Region of the resource. | string | Yes |
| resource\$1arn | The Amazon Resource Name (ARN) of the resource. | string | Yes |
| restart\$1needed | Whether or not implementing the recommendation requires a restart. | boolean | No |
| rollback\$1possible | Whether or not implementing the recommendation can be rolled back. | boolean | No |
| tags | A list of tags associated with the resource for which the recommendation exists. | map | Yes |
# FOCUS 1.2 with AWS columns
The FOCUS 1.2 with AWS columns table contains your cost and usage data formatted with FinOps Open Cost and Usage Specification (FOCUS) 1.0, along with three additional columns from AWS that contain proprietary billing data. These columns are **x\$1Discounts**, **x\$1Operation**, and **x\$1ServiceCode**. For more information about the FOCUS open-source specification, refer to the [FOCUS](https://focus.finops.org/) website.
The SQL table name for FOCUS 1.2 with AWS columns is `FOCUS_1_2_AWS`
## Table configurations
Table configurations are user-controlled properties that a user can set to change the data or schema of a table before it's queried in Data Exports. The table configurations are saved as a JSON statement and are either specified through user input in the AWS SDK/CLI or user selections in the console.
FOCUS 1.2 has the following table configurations:
| Configuration name | Description | Valid values |
| --- | --- | --- |
| TIME\$1GRANULARITY | This configuration changes the cost and usage line items in the FOCUS 1.2 table to have different time granularities. For example, selecting "HOURLY" will make all line items represent a single hour of usage. | HOURLY, DAILY, MONTHLY |
## AWS Organizations support
The FOCUS 1.2 with AWS columns table inherits the settings you made in the consolidated billing feature in AWS Organizations. When consolidated billing is enabled, there are different behaviors for management and member accounts. If you’re using a management account, your FOCUS 1.2 with AWS columns table includes cost and usage data for the management account and all member accounts in your organization. If you’re using a member account, your FOCUS 1.2 with AWS columns table only includes cost and usage data for that member account.
After joining an organization, a member account can only export data for the time that the account has been a member of the organization. For example, let's say that a member account leaves organization A and joins organization B on the 15th of the month. Then, the member account creates an export. Because the member account created an export after joining organization B, the member account’s export of FOCUS 1.2 with AWS columns for the month only includes cost and usage data for the time that the account has been a member of organization B.
# FOCUS 1.2 with AWS columns
| Column name | Description | Data type | Null value allowed |
| --- | --- | --- | --- |
| AvailabilityZone | A provider-assigned identifier for a physically separated and isolated area within a Region that provides high availability and fault tolerance. | string | Yes |
| BilledCost | A charge serving as the basis for invoicing, inclusive of all reduced rates and discounts while excluding the amortization of upfront charges (one-time or recurring). | double | No |
| BillingAccountId | The identifier assigned to a billing account by the provider. | string | No |
| BillingAccountName | The display name assigned to a billing account. | string | Yes |
| BillingAccountType | A provider-assigned name to identify the type of billing account. | string | No |
| BillingCurrency | Represents the currency that a charge was billed in. | string | No |
| BillingPeriodEnd | The exclusive end bound of a billing period. | timestamp\$1milliseconds | No |
| BillingPeriodStart | The inclusive start bound of a billing period. | timestamp\$1milliseconds | No |
| CapacityReservationId | The identifier assigned to a capacity reservation by the provider. | string | Yes |
| CapacityReservationStatus | Indicates whether the charge represents either the consumption of a capacity reservation or when a capacity reservation is unused. | string | Yes |
| ChargeCategory | Represents the highest-level classification of a charge based on the nature of how it is billed. | string | No |
| ChargeClass | Indicates whether the row represents a correction to a previously invoiced billing period. | string | Yes |
| ChargeDescription | Self-contained summary of the charge's purpose and price. | string | Yes |
| ChargeFrequency | Indicates how often a charge will occur. | string | No |
| ChargePeriodEnd | The exclusive end bound of a charge period. | timestamp\$1milliseconds | No |
| ChargePeriodStart | The inclusive start bound of a charge period. | timestamp\$1milliseconds | No |
| CommitmentDiscountCategory | Indicates whether the commitment discount identified in the CommitmentDiscountId column is based on usage quantity or cost (aka "spend"). | string | Yes |
| CommitmentDiscountId | The identifier assigned to a commitment discount by the provider. | string | Yes |
| CommitmentDiscountName | The display name assigned to a commitment discount. | string | Yes |
| CommitmentDiscountQuantity | The amount of a commitment discount purchased or accounted for in commitment discount related rows that is denominated in Commitment Discount Units. | double | Yes |
| CommitmentDiscountStatus | Indicates whether the charge corresponds with the consumption of a commitment discount or the unused portion of the committed amount. | string | Yes |
| CommitmentDiscountType | A provider-assigned identifier for the type of commitment discount applied to the row. | string | Yes |
| CommitmentDiscountUnit | The provider-specified measurement unit indicating how a provider measures the Commitment Discount Quantity of a commitment discount. | string | Yes |
| ConsumedQuantity | The volume of a metered SKU associated with a resource or service used, based on the Consumed Unit. | double | Yes |
| ConsumedUnit | Provider-specified measurement unit indicating how a provider measures usage of a metered SKU associated with a resource or service. | string | Yes |
| ContractedCost | Cost calculated by multiplying contracted unit price and the corresponding Pricing Quantity. | double | No |
| ContractedUnitPrice | The agreed-upon unit price for a single Pricing Unit of the associated SKU, inclusive of negotiated discounts, if present, while excluding negotiated commitment discounts or any other discounts. | double | Yes |
| EffectiveCost | The amortized cost of the charge after applying all reduced rates, discounts, and the applicable portion of relevant, prepaid purchases (one-time or recurring) that covered this charge. | double | No |
| InvoiceId | The provider-assigned identifier for an invoice encapsulating some or all charges in the corresponding billing period for a given billing account. | string | Yes |
| InvoiceIssuerName | The name of the entity responsible for invoicing for the resources or services consumed. | string | No |
| ListCost | Cost calculated by multiplying List Unit Price and the corresponding Pricing Quantity. | double | No |
| ListUnitPrice | The suggested provider-published unit price for a single Pricing Unit of the associated SKU, exclusive of any discounts. | double | Yes |
| PricingCategory | Describes the pricing model used for a charge at the time of use or purchase. | string | Yes |
| PricingCurrency | The national or virtual currency denomination that a resource or service was priced in. | string | Yes |
| PricingCurrencyContractedUnitPrice | The agreed-upon unit price for a single Pricing Unit of the associated SKU, inclusive of negotiated discounts, if present, while excluding negotiated commitment discounts or any other discounts, and expressed in Pricing Currency. | double | Yes |
| PricingCurrencyEffectiveCost | The cost of the charge after applying all reduced rates, discounts, and the applicable portion of relevant, prepaid purchases (one-time or recurring) that covered this charge, as denominated in Pricing Currency. | double | Yes |
| PricingCurrencyListUnitPrice | The suggested provider-published unit price for a single Pricing Unit of the associated SKU, exclusive of any discounts and expressed in Pricing Currency. | double | Yes |
| PricingQuantity | The volume of a given SKU associated with a resource or service used or purchased, based on the Pricing Unit. | double | Yes |
| PricingUnit | Provider-specified measurement unit for determining unit prices, indicating how the provider rates measured usage and purchase quantities after applying pricing rules like block pricing. | string | Yes |
| ProviderName | The name of the entity that made the resources or services available for purchase. | string | No |
| PublisherName | The name of the entity that produced the resources or services that were purchased. | string | No |
| RegionId | Provider-assigned identifier for an isolated geographic area where a resource is provisioned or a service is provided. | string | Yes |
| RegionName | The name of an isolated geographic area where a resource is provisioned or a service is provided. | string | Yes |
| ResourceId | Identifier assigned to a resource by the provider. | string | Yes |
| ResourceName | Display name assigned to a resource. | string | Yes |
| ResourceType | The kind of resource the charge applies to. | string | Yes |
| ServiceCategory | Highest-level classification of a service based on the core function of the service. | string | No |
| ServiceName | An offering that can be purchased from a provider (e.g., cloud virtual machine, SaaS database, professional services from a systems integrator). | string | No |
| ServiceSubcategory | Secondary classification of the Service Category for a service based on its core function. | string | No |
| SkuId | Provider-specified unique identifier that represents a specific SKU (e.g., a quantifiable good or service offering). | string | Yes |
| SkuMeter | Describes the functionality being metered or measured by a particular SKU in a charge. | string | Yes |
| SkuPriceId | A provider-specified unique identifier that represents a specific SKU Price associated with a resource or service used or purchased. | string | Yes |
| SkuPriceDetails | A set of properties of a SKU Price ID which are meaningful and common to all instances of that SKU Price ID. | map | Yes |
| SubAccountId | An ID assigned to a grouping of resources or services, often used to manage access and/or cost. | string | Yes |
| SubAccountName | A name assigned to a grouping of resources or services, often used to manage access and/or cost. | string | Yes |
| SubAccountType | A provider-assigned name to identify the type of sub account. | string | Yes |
| Tags | The set of tags assigned to tag sources that account for potential provider-defined or user-defined tag evaluations. | map | Yes |
| x\$1Discounts | A map column containing key-value pairs of any specific discounts that apply to this line item. | map | Yes |
| x\$1Operation | The specific AWS operation covered by this line item. This describes the specific usage of the line item. For example, a value of RunInstances indicates the operation of an Amazon EC2 instance. | string | Yes |
| x\$1ServiceCode | The code of the product measured. For example, Amazon EC2 is the product code for Amazon Elastic Compute Cloud. | string | Yes |
# FOCUS 1.2 with AWS columns conformance gaps
The following table provides all of the conformance gaps that might exist in an export of the FOCUS 1.2 with AWS columns table. A particular conformance gap will not apply to your export if you're not receiving cost and usage data for the related scenario.
****
[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-focus-1-2-aws-conformance.html)
# Migrating from FOCUS 1.0 to FOCUS 1.2
AWS Data Exports allows you to create exports of FOCUS 1.2 with AWS columns, which provides the same standardized cost and usage information as FOCUS 1.0 along with several enhancements for invoice reconciliation, capacity reservation tracking, and SaaS integration. However, FOCUS 1.2 introduces breaking changes that affect existing row counts and column values. Review these changes carefully before migrating.
FOCUS 1.2 provides the following improvements over FOCUS 1.0:
+ Invoice reconciliation: FOCUS 1.2 includes an InvoiceID column that enables streamlined financial close processes and invoice reconciliation.
+ Capacity reservation tracking: FOCUS 1.2 contains CapacityReservationId and CapacityReservationStatus columns that help you identify and track unused capacity reservations.
+ Virtual currency support: FOCUS 1.2 includes new pricing currency columns (PricingCurrency, PricingCurrencyEffectiveCost, PricingCurrencyListUnitPrice, and PricingCurrencyContractedUnitPrice) that enable you to join with SaaS providers cost and usage data in FOCUS 1.2 format.
The following table outlines the differences between FOCUS 1.2 and FOCUS 1.0 in more detail:
| Feature | FOCUS 1.2 | FOCUS 1.0 |
| --- | --- | --- |
| Data schema | FOCUS 1.2 specification with 57 FOCUS columns \$1 3 AWS columns (60 total). For the complete column list, see FOCUS 1.2 with AWS columns. | FOCUS 1.0 specification with 43 FOCUS columns \$1 5 AWS columns (48 total). For the complete column list, see FOCUS 1.0 with AWS columns. |
| New columns | InvoiceIssuerId, CapacityReservationId, CapacityReservationStatus, CommitmentDiscountQuantity, CommitmentDiscountUnit, ServiceSubcategory, SkuMeter, SkuPriceDetails, PricingCurrency, PricingCurrencyEffectiveCost, PricingCurrencyListUnitPrice, PricingCurrencyContractedUnitPrice, BillingAccountType, SubAccountType | |
| Removed columns | x\$1UsageType (This is now the SkuMeter column) x\$1CostCategories (This is now included in the Tags column with the "aws:tags:CostCategory/" prefix) | |
| Row count | On Demand Capacity Reservation (ODCR) and EC2 Capacity Blocks for ML line items are now split into separate "Used" and "Unused" status. This increases the row count. | Does not provide capacity reservation status breakdown details. |
| PricingCategory column values | Commitment discount purchases, such as Reserved Instance and Savings Plan upfront fees, are now categorized as "Standard." | Commitment discount purchases categorized as "Committed". |
| ConsumedQuantity column nullability | Null when the CommitmentDiscountStatus is "Unused". | Value is "0" when the CommitmentDiscountStatus is "Unused". |
| ConsumedUnit column nullability | Tied to ConsumedQuantity nullability (required to be null when ConsumedQuantity is null). | Independent nullability rules. |
| Tag column requirement | Include user-defined and provider-defined resource tags, and user-defined cost category tags. | Include only user-defined and provider-defined resource tags. |
| File delivery destination | S3 bucket | S3 bucket |
| File output formats | GZIP, Parquet | GZIP, Parquet |
| SQL table name | FOCUS\$11\$12\$1AWS | FOCUS\$11\$10\$1AWS |
| Manifest FocusVersion | "1.2" | "1.0" |
| Table configurations | Allows TIME\$1GRANULARITY to be set to HOURLY, DAILY, or MONTHLY | Only exports in HOURLY. |
For more detailed information about the schema of FOCUS 1.2, see [FOCUS 1.2 with AWS columns](table-dictionary-focus-1-2-aws.md).
# FOCUS 1.0 with AWS columns
The FOCUS 1.0 with AWS columns table contains your cost and usage data formatted with FinOps Open Cost and Usage Specification (FOCUS) 1.0, along with five additional columns from AWS that contain proprietary billing data. These columns are **x\$1CostCategories**, **x\$1Discounts**, **x\$1Operation**, **x\$1ServiceCode**, and **x\$1UsageType**. For more information about the FOCUS open-source specification, refer to the [FOCUS](https://focus.finops.org/) website.
The SQL table name for FOCUS 1.0 with AWS columns is `FOCUS_1_0_AWS`
## Table configurations
There are no table configurations for the FOCUS 1.0 with AWS columns table.
## AWS Organizations support
The FOCUS 1.0 with AWS columns table inherits the settings you made in the consolidated billing feature in AWS Organizations. When consolidated billing is enabled, there are different behaviors for management and member accounts. If you’re using a management account, your FOCUS 1.0 with AWS columns table includes cost and usage data for the management account and all member accounts in your organization. If you’re using a member account, your FOCUS 1.0 with AWS columns table only includes cost and usage data for that member account.
After joining an organization, a member account can only export data for the time that the account has been a member of the organization. For example, let's say that a member account leaves organization A and joins organization B on the 15th of the month. Then, the member account creates an export. Because the member account created an export after joining organization B, the member account’s export of FOCUS 1.0 with AWS columns for the month only includes cost and usage data for the time that the account has been a member of organization B.
# FOCUS 1.0 with AWS columns
| Column name | Description | Data type | Null value allowed |
| --- | --- | --- | --- |
| AvailabilityZone | A provider-assigned identifier for a physically separated and isolated area within a Region that provides high availability and fault tolerance. | string | Yes |
| BilledCost | A charge that is the basis for invoicing, inclusive of all reduced rates and discounts while excluding the amortization of relevant purchases paid to cover future eligible charges. | double | No |
| BillingAccountId | A provider-assigned identifier for a billing account. | string | No |
| BillingAccountName | A provider-assigned name for a billing account. | string | Yes |
| BillingCurrency | An identifier that represents the currency that a charge for resources or services was billed in. | string | No |
| BillingPeriodEnd | The end date and time of the billing period. | timestamp\$1milliseconds | No |
| BillingPeriodStart | The start date and time of the billing period. | timestamp\$1milliseconds | No |
| ChargeCategory | An indicator of whether the row represents an upfront or recurring fee, cost of usage that already occurred, an after-the-fact adjustment (for example, credits), or taxes. | string | No |
| ChargeClass | An indicator of whether the row represents a regular charge, or a correction to one or more previous charges. | string | Yes |
| ChargeDescription | A high-level context of a row without requiring additional discovery. | string | Yes |
| ChargeFrequency | An indicator of how often a charge will occur. | string | No |
| ChargePeriodEnd | The end date and time of the charge period. | timestamp\$1milliseconds | No |
| ChargePeriodStart | The start date and time of the charge period. | timestamp\$1milliseconds | No |
| CommitmentDiscountCategory | An indicator of whether the commitment-based discount identified in the CommitmentDiscountId column is based on usage quantity or cost (that is, spend). | string | Yes |
| CommitmentDiscountId | A provider-assigned identifier for a commitment-based discount. | string | Yes |
| CommitmentDiscountName | The display name assigned to a commitment-based discount. | string | Yes |
| CommitmentDiscountStatus | An indicator of whether the charge corresponds to a used or unused commitment discount. | string | Yes |
| CommitmentDiscountType | A provider-assigned name to identify the type of commitment-based discount applied to the row. | string | Yes |
| ConsumedQuantity | The volume of a given resource or service used or purchased based on the ConsumedUnit. | double | Yes |
| ConsumedUnit | A provider-assigned measurement unit indicating how a provider measures usage of a given SKU associated with a resource or service. | string | Yes |
| ContractedCost | The cost calculated by multiplying ContractedUnitPrice and the corresponding PricingQuantity. | double | No |
| ContractedUnitPrice | The agreed-upon unit price for a single PricingUnit of the associated SKU, inclusive of any negotiated discounts while excluding negotiated commitment-based discounts or any other discounts. | double | Yes |
| EffectiveCost | A cost that includes all reduced rates and discounts, augmented with the amortization of relevant purchases (one-time or recurring) paid to cover future eligible charges. | double | No |
| InvoiceIssuerName | An entity responsible for invoicing the sources or services consumed. It is commonly used for cost analysis and reporting scenarios. | string | No |
| ListCost | The cost calculated by multiplying ListUnitPrice and the corresponding PricingQuantity. | double | No |
| ListUnitPrice | The suggested unit price, published by the provider, for a single PricingUnit of the associated SKU, excluding any discounts. | double | Yes |
| PricingCategory | The pricing model used for a charge at the time of use or purchase. | string | Yes |
| PricingQuantity | The volume of a given SKU associated with a resource or service used or purchased, based on the PricingUnit. | double | Yes |
| PricingUnit | A provider-assigned measurement unit for determining unit prices, indicating how the provider rates measured usage and purchase quantities after applying pricing rules such as block pricing. | string | Yes |
| ProviderName | The entity that made the resources or services available for purchase. | string | No |
| PublisherName | The entity that produced the resources or services that were purchased. | string | No |
| RegionId | A provider-assigned identifier for an isolated geographic area where a resource is provisioned or a service is provided. | string | Yes |
| RegionName | The name of an isolated geographic area where a resource is provisioned or a service is provided. | string | Yes |
| ResourceId | A provider-assigned identifier for a resource. | string | Yes |
| ResourceName | A display name assigned to a resource. | string | Yes |
| ResourceType | The type of resource the charge applies to. | string | Yes |
| ServiceCategory | The highest-level classification of a service based on the core function of the service. | string | No |
| ServiceName | A display name for the offering that was purchased. | string | No |
| SkuId | A unique identifier that defines a provider-supported construct for organizing properties that are common across one or more SKU prices. | string | Yes |
| SkuPriceId | A unique identifier that defines the unit price used to calculate the charge. | string | Yes |
| SubAccountId | An ID assigned to a grouping of resources or services, often used to manage access and/or cost. | string | Yes |
| SubAccountName | A name assigned to a grouping of resources or services, often used to manage access and/or cost. | string | Yes |
| Tags | The set of tags assigned to tag sources that also account for potential provider-defined or user-defined tag evaluations. | map | Yes |
| x\$1CostCategories | A map column containing key-value pairs of the cost categories and their values for a given line item. | map | Yes |
| x\$1Discounts | A map column containing key-value pairs of any specific discounts that apply to this line item. | map | Yes |
| x\$1Operation | The specific AWS operation covered by this line item. This describes the specific usage of the line item. | string | Yes |
| x\$1ServiceCode | The code of the service used in this line item. | string | Yes |
| x\$1UsageType | The usage details of the line item. | string | Yes |
# FOCUS 1.0 with AWS columns conformance gaps
The following table provides all of the conformance gaps that might exist in an export of the FOCUS 1.0 with AWS columns table. A particular conformance gap will not apply to your export if you're not receiving cost and usage data for the related scenario.
****
[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-focus-1-0-aws-conformance.html)
# Cost and usage dashboard
The SQL table name for cost and usage dashboard is `COST_AND_USAGE_DASHBOARD`.
## Table configurations
Table configurations are user-controlled properties that a user can set to change the data or schema of a table before it's queried in Data Exports.
The Cost and Usage Dashboard does not have any modifiable table configurations.
## AWS Organizations support
The cost and usage dashboard table is generated from CUR 2.0 data, which means that it inherits the same AWS Organizations settings that apply to CUR 2.0 and the same behavior applies. To understand how AWS Organizations applies to the cost and usage dashboard, refer to [AWS Organizations support](https://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur2.html#cur2-table-organizations) in the CUR 2.0 section.
## Cost and usage dashboard columns
****
| Column name | Description |
| --- | --- |
| amortized\$1cost | The effective cost of the upfront and monthly reservation fees spread across the billing period. This is the sum of costs based on the type of line item. The cost is determined as follows:[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| availability\$1zone | The Availability Zone that hosts this line item. For example, us-east-1a or us-east-1b. |
| billing\$1entity | Helps you identify whether your invoices or transactions are for AWS Marketplace or for purchases of other AWS services. Possible values include:**AWS:** Identifies a transaction for AWS services other than in AWS Marketplace.**AWS Marketplace:** Identifies a purchase in AWS Marketplace. |
| billing\$1period | The start date of the billing period that is covered by dashboard, in UTC. The format is `YYYY-MM-DDTHH:mm:ssZ`. **Example:** 2023-10-01T00:00:00.000Z |
| charge\$1category | The category of the charge covered by this line item. The following are the possible categories:Running\$1usage: When the charge\$1type is one of the following: ‘DiscountedUsage’, SavingsPlanCoveredUsage’, or ‘Usage’.Non\$1Usage: For everything else under charge\$1type. |
| charge\$1type | The type of charge covered by this line item. See lineItem/LineItemType here for all the possible values. |
| current\$1generation | Helps you identify whether your Amazon RDS instance is of current generation or not. |
| database\$1engine | Describes the database engine of your database.**Examples:** PostgreSQL, Oracle. |
| instance\$1type | Describes the instance type, size, and family, which define the CPU, networking, and storage capacity of your instance.**Examples:** t2.small, m4.xlarge, t2.micro, m4.large, t2.largeServices:[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| instance\$1type\$1family | The instance family that is associated with the given usage.**Examples:** t2, m4, m3**Services:**[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| invoice\$1id | The ID associated with a specific line item. The invoice\$1id remains blank until the export is final. |
| item\$1description | The description of the line item type. For example, the description of a usage line item summarizes what type of usage you incurred during a specific time period.For size-flexible RIs, the description corresponds to the RI the benefit was applied to. For example, if a line item corresponds to a t2.micro and a t2.small RI was applied to the usage, the lineItem/LineItemDescription displays t2.small.The description for a usage line item with an RI discount contains the pricing plan covered by the line item. |
| legal\$1entity | The Seller of Record of a specific product or service. In most cases, the invoicing entity and legal entity are the same. The values might differ for third-party AWS Marketplace transactions. Possible values include:**Amazon Web Services, Inc. :** The entity that sells AWS services.**Amazon Web Services India Private Limited :** The local Indian entity that acts as a reseller for AWS services in India. |
| linked\$1account\$1id | The account ID of the account that used this line item. For organizations, this can be either the management account or a member account. You can use this field to track costs or usage by account. |
| linked\$1account\$1name | The name of the account that used this line item. For organizations, this can be either the management account or a member account. You can use this field to track costs or usage by account. |
| operation | The specific AWS operation covered by this line item. This describes the specific usage of the line item. For example, a value of RunInstances indicates the operation of an Amazon EC2 instance. |
| payer\$1account\$1id | The account ID of the paying account. For an organization in AWS Organizations, this is the account ID of the management account. |
| payer\$1account\$1name | The account name of the paying account. For an organization in AWS Organizations, this is the name of the management account. |
| platform | Describes the operating system of your Amazon EC2 instance.**Examples:** Amazon Linux, Ubuntu, Windows Server, Oracle Linux, FreeBSD**Services:**[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| pricing\$1unit | The pricing unit that AWS used for calculating your usage cost. For example, the pricing unit for Amazon EC2 instance usage is in hours. |
| processor | Describes the processor on your Amazon EC2 instance.**Examples:** High Frequency Intel Xeon E7-8880 v3 (Haswell), Intel Xeon E5-2670, AMD EPYC 7571**Services:**[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| processor\$1features | Describes the processor features of your instances.**Examples:** Intel AVX, Intel AVX2, Intel AVX512, Intel Turbo**Services:**[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| product\$1code | The code of the product measured. For example, AmazonEC2 is the product code for Amazon Elastic Compute Cloud. |
| product\$1family | The category for the type of product.**Examples:**Alarm, AWS Budgets, Stopped Instance, Storage Snapshot, Compute |
| product\$1from\$1location | Describes the location where the usage originated from.**Sample values:** External, US East (N. Virginia), Global**Services:**[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| product\$1group | A construct of several products that are similar by definition, or grouped together. For example, the Amazon EC2 team can categorize their products into shared instances, dedicated host, and dedicated usage.**Services:**[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| product\$1name | The full name of the AWS service.**Examples:** AWS Backup, AWS Config, Amazon Registrar, Amazon Elastic File System, Amazon Elastic Compute Cloud |
| product\$1to\$1location | Describes the location usage destination.**Sample values:** External, US East (N. Virginia)**Services:**[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| public\$1cost | The total cost for the line item based on public On-Demand Instance rates. If you have SKUs with multiple On-Demand public costs, the equivalent cost for the highest tier is displayed. For example, services offering free-tiers or tiered pricing. |
| purchase\$1option | The way in which you acquired and paid for the AWS resource in this line item. The purchase\$1option column contains ‘SavingsPlan’, ‘Reserved’, or ‘Spot’ for savings plans, reserved instances, and spot instances respectively. The purchase\$1option column has ‘OnDemand’ for the remaining records. |
| region | The geographical area that hosts your AWS services. Use this field to analyze spend across a particular Region.**Examples:** eu-west-3, us-west-1, us-east-1, ap-northeast-2, sa-east-1**Services:**[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| ri\$1sp\$1arn | The unique Savings Plan or Reserved Instance identifier. It typically follows the format arn: aws: savingsplans: ::savingsplan/ or arn: aws:ec2::reserved-instances/. |
| ri\$1sp\$1trueup | This is the sum of adjustments based on the type of line item. True-up represents the difference between total upfront fees incurred in the period using an unblended cost, and the smaller portion of upfront fees applicable to the period using an amortized cost. The adjustment is determined as follows:[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| ri\$1sp\$1upfront\$1fee | The upfront fee refers to the initial payment you make when you choose certain types of Reserved Instances or Savings Plans. |
| service | The name of the AWS service.**Examples:** AmazonVPC, AmazonRDS, AmazonRoute53 etc. |
| tenancy | The type of tenancy allowed on the Amazon EC2 instance.**Examples:** Dedicated, Reserved, Shared, NA, Host**Services:**[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/cur/latest/userguide/table-dictionary-cur-dashboard.html) |
| unblended\$1cost | The UnblendedCost is the UnblendedRate multiplied by the UsageAmount. |
| usage\$1date | The start date and time for the line item in UTC. The format is `YYYY-MM-DDTHH:mm:ssZ`. **Example:** 2023-10-01T00:00:00.000Z |
| usage\$1quantity | The amount of usage that you incurred during the specified time period. For size-flexible Reserved Instances, use the reservation/TotalReservedUnits column instead. Certain subscription charges will have a UsageAmount of 0. |
| usage\$1type | The usage details of the line item. For example, USW2-BoxUsage:m2.2xlarge describes an M2 High Memory Double Extra Large instance in the US West (Oregon) Region. |
# Carbon emissions
The carbon emissions table contains your estimated carbon emissions. It provides detailed account-level and regional granularity of your carbon emissions data. You can configure automated monthly deliveries to Amazon S3 in either CSV or Parquet format, making it simple to integrate with your existing business intelligence tools and reporting systems. For detailed information about the methodology, see [Calculation Methodology](https://docs.aws.amazon.com/sustainability/latest/userguide/methodology.html) in the *AWS Sustainability User Guide*.
The SQL table name for carbon emissions is `CARBON_EMISSIONS`.
## Historical data
You will receive data going back up to January 2022 within 24 hours of setup, enabling you to perform baseline analysis and trend reporting without manual data gathering.
## Table configurations
There are no table configurations for the Carbon emissions table.
## Permissions
To access carbon footprint data, you need the IAM permission `sustainability:GetCarbonFootprintSummary`.
## Model versions
The methodology for calculating your carbon emissions will evolve over time to better reflect your usage and align with carbon accounting best practices. Exports are partitioned in hierarchical order by “model\$1version=Y/” and “usage\$1period=YYYY-MM/”. The “model\$1version” partition that an export is stored under will correspond to the model version used to generate that export, while the “usage\$1period” partition corresponds to the dates the carbon emissions were generated. This structure enables you to differentiate between data with the old and new models by viewing the partition names.
## AWS Organizations support
The Carbon emissions table inherits the settings you made in the consolidated billing feature in AWS Organizations. When consolidated billing is enabled, there are different behaviors for management and member accounts. If you’re using a management account, your Carbon emissions table includes estimated carbon emissions data for the management account and all member accounts in your organization. If you’re using a member account, your Carbon emissions table only includes estimated carbon emissions data for that member account.
After a member account joins a new organization, or a management account converts to a member account and joins a new organization, the account's carbon emissions data is recorded in the new organization's exports. Each management account contains member accounts' data for the time period it was linked to said management account. For example, a member account leaves organization A and joins organization B on the 15th of the month. Then, the member account creates an export. Because the member account created an export after joining organization B, the member account’s export of the Carbon emissions table for the month includes estimated carbon emissions data for the time that the account has been a member of organization B.
When a member account leaves an organization or converts to a standalone account, the member account can still access previous exports if it has permissions to the Amazon S3 bucket where those exports are stored. Carbon emissions associated with terminated or suspended accounts will appear in the management account data exports for the periods when these accounts were active.
For more information, see [Consolidated billing for AWS Organizations](https://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/consolidated-billing.html) in the *AWS Billing User Guide*.
# Carbon emissions columns
| Column name | Description | Data type | Null value allowed |
| --- | --- | --- | --- |
| last\$1refresh\$1timestamp | The time when the carbon footprint value was last generated, in UTC. The format is `YYYY-MM-DD HH:mm:ssZ`. | timestamp | No |
| location | Describes the human-readable location where the usage originated from, corresponding to the region\$1code. For example, US East (N. Virginia). Emissions from Global Services, such as Amazon CloudFront, are reported under Global. | string | Yes |
| model\$1version | The version of the methodology the carbon footprint data was calculated with. For example, v2.0.0. | string | No |
| payer\$1account\$1id | The account ID of the paying account. For an organization in AWS Organizations, this is the account ID of the management account. | string | No |
| product\$1code | The code of the product measured. For example, Amazon EC2 is the product code for Amazon Elastic Compute Cloud. | string | Yes |
| region\$1code | A Region is a physical location around the world where data centers are clustered. AWS calls each group of logical data centers an Availability Zone (AZ). Each AWS Region consists of multiple, isolated, and physically separate AZs within a geographical area. The Region code attribute has the same name as an AWS Region, and specifies where the AWS service is available. For example, us-east-1. | string | Yes |
| total\$1lbm\$1emissions\$1unit | The unit of measure used for location-based method (LBM) emissions. The unit we currently support is metric tons of carbon dioxide-equivalent (MTCO2e). | string | Yes |
| total\$1lbm\$1emissions\$1value | The total estimated location-based method (LBM) emissions value associated with the account. | double | Yes |
| total\$1mbm\$1emissions\$1unit | The unit of measure used for market-based method (MBM) emissions. The unit we currently support is metric tons of carbon dioxide-equivalent (MTCO2e). | string | Yes |
| total\$1mbm\$1emissions\$1value | The total estimated market-based method (MBM) emissions value associated with the account. | double | Yes |
| total\$1scope\$11\$1emissions\$1value | The Scope 1 emissions value associated with the account. | double | No |
| total\$1scope\$11\$1emissions\$1unit | The unit of measure used for Scope 1 emissions. | string | No |
| total\$1scope\$12\$1lbm\$1emissions\$1value | The Scope 2 location-based method (LBM) emissions value associated with the account. | double | No |
| total\$1scope\$12\$1lbm\$1emissions\$1unit | The unit of measure used for Scope 2 location-based method (LBM) emissions. | string | No |
| total\$1scope\$12\$1mbm\$1emissions\$1value | The Scope 2 market-based method (MBM) emissions value associated with the account. | double | No |
| total\$1scope\$12\$1mbm\$1emissions\$1unit | The unit of measure used for Scope 2 market-based method (MBM) emissions. | string | No |
| total\$1scope\$13\$1lbm\$1emissions\$1value | The Scope 3 location-based method (LBM) emissions value associated with the account. | double | No |
| total\$1scope\$13\$1lbm\$1emissions\$1unit | The unit of measure used for Scope 3 location-based method (LBM) emissions. | string | No |
| total\$1scope\$13\$1mbm\$1emissions\$1value | The Scope 3 market-based method (MBM) emissions value associated with the account. | double | No |
| total\$1scope\$13\$1mbm\$1emissions\$1unit | The unit of measure used for Scope 3 market-based method (MBM) emissions. | string | No |
| usage\$1account\$1id | The account ID of the account associated with the carbon footprint value. For organizations, this can be either the management account or a member account. | string | No |
| usage\$1period\$1end | The end date of the period that is covered by this report, in UTC. The format is `YYYY-MM-DD HH:mm:ssZ`. | timestamp | No |
| usage\$1period\$1start | The start date of the period that is covered by this report, in UTC. The format is `YYYY-MM-DD HH:mm:ssZ`. | timestamp | No |