Cost and Usage Report (CUR) 2.0 - Amazon Data Exports
Table configurationsAmazon Organizations supportCUR 2.0 column groups
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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 Amazon 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 two additional columns: bill_payer_account_name and line_item_usage_account_name.

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 Amazon SDK/CLI or user selections in the console.

CUR 2.0 has the following table configurations:

Configuration name Description Valid values
TIME_GRANULARITY

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_RESOURCES

This configuration changes the cost and usage line items in the CUR 2.0 table to have resource-level granularity and adds the "line_item_resource_id" 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_SPLIT_COST_ALLOCATION_DATA

This configuration adds split cost allocation data and columns (split_line_item_*) to the CUR 2.0 table. This data indicates how the usage of certain Amazon 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.

 TRUE, FALSE
INCLUDE_MANUAL_DISCOUNT_COMPATIBILITY

Note: This configuration only applies to Amazon 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_discount").

 TRUE, FALSE

Amazon Organizations support

The CUR 2.0 table inherits the settings you made in the consolidated billing feature in Amazon 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 Amazon Organizations in the Amazon 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.

  • 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.