AWS Data Tables

Overview

Purchases generated by the AWS connector contain purchase metadata specific to AWS usage. CloudBilling retrieves this information from the AWS Cost and Usage Reports (CURs). The LineItems associated with these purchases retain the metadata. Since most metadata fields have string type values, they are stored in separate tables in the dataset to improve storage and performance efficiency. Each table is linked to a LineItem using its primary key. Refer to the external documentation AWS CUR Data Dictionary for further information on the fields listed in all the tables.

AwsAccounts

You can have multiple AWS usage accounts. Each account is used to create and manage AWS resources, with costs tied to the services and resources used within it. The account ID is a twelve-digit number that uniquely identifies the account. The AWS resources include the account ID in their Amazon Resource Names (ARNs). By linking this table to the LineItems table, you can find the account ID each LineItem belongs to.

Name Type Description
Key Integer Primary Key - AwsAccounts Table.
AWSUsageAccountId String Usage account ID in AWS Partner Central.
CustomerCode String The customer code in CloudBilling.

AwsDescription

This table contains the description of a usage line summarising what type of usage was incurred during a specific time period. For example, the description for a virtual private cloud purchase will indicate the price for each client connection per hour as “$0.05 per Client VPN Connection Hour”. By linking this table with the LineItems table, you can retrieve the usage description associated with all AWS LineItems.

Name Type Description
Key Integer Primary Key - AwsDescription Table.
Description String Usage description in AWS purchase line.
CustomerCode String The customer code in CloudBilling.

AwsInvoices

AWS Source data (Cost and Usage Report and AWS Invoice) provides the information with the transaction dates. The report of August contains products like SPPDiscounts that can be dated to the future invoices, which would result in the transaction date not matching the AWS report date. In order to filter the information based on the AWS report date, the AWS invoice dates are added as extra fields to the dataset.

Name Type Description
Key Integer Primary Key - AwsInvoices Table.
AwsInvoiceStart Integer Foreign Key - Invoice start date (yyyymmdd).
AwsInvoiceEnd Integer Foreign Key - Invoice end date (yyyymmdd).

AwsProducts

The AWS Cost and Usage report is used as the source of truth for the purchases. Hence, the additional product data from that report are retrieved to purchase metadata. In the dataset, AwsProducts table contains this information. Joining this table with the LineItems table will provide additional AWS product details associated with a LineItem.

Name Type Description
Key Integer Primary Key - AwsProducts Table.
ItemAvailabilityZone String The Availability Zone that hosts the usage.
ItemOperation String The specific AWS operation covered by this line item.
ItemType String The type of charge - BundledDiscount, Credit, Discount, DiscountedUsage, Fee, Refund, RIFee, Tax, Usage, SavingsPlanUpfrontFee, SavingsPlanRecurringFee, SavingsPlanRecurringUsage, and SavingsPlanNegation.
ItemUsageType String The usage details of a purchase corresponding to the details of the lineitem in the AWS Cost and Usage report. For example, USW2-BoxUsage:m2.2xlarge describes an M2 High Memory Double Extra Large instance in the US West (Oregon) Region
ItemProductCode String The product code in AWS Partner Central. For example, Amazon EC2 is the product code for Amazon Elastic Compute Cloud.
ServiceCode String Identifies the specific AWS service, such as awskms and ComputeSavingsPlans.
ServiceName String A simplified description about the AWS service.
Location String The Region your Amazon S3 bucket resides in.
InstanceType String The instance type, size, and family, which define the CPU, networking, and storage capacity. For example, t2.nano describes a low cost instance with baseline RAM and CPU performance.
ProductFamily String The category for the type of product in AWS Partner Central, such as Storage Snapshot, Stopped Instance, AWS Budgets, and Compute. This information is indicated in the AWS Cost and Usage report.
ProductName String The full name of the AWS service.
Sku String A unique code for a product. For example, QA3B8ZCM893VX9GF is the SKU for the AmazonEC2 Compute Instance product AFS1-BoxUsage:c5.12xlarge - RunInstances:0210.

AwsReservations

For certain services like Amazon EC2 and Amazon RDS, reservations are available as cost-saving options over on-demand instance pricing. Refer to the external documentation Reservations for more contextual information on what Reservations are. All AWS reservation purchases contain reservation details as purchase metadata. The following table contains these reservation details. Combining this table with the LineItems table will provide the reservation details associated with a LineItem.

Name Type Description
Key Integer Primary Key - AwsReservations Table.
ReservationStart Integer Foreign Key - The start date of the associated Reservation (yyyymmdd).
ReservationEnd Integer Foreign Key - The end date of the associated Reservation (yyyymmdd).
ReservationArn String The Amazon Resource Name (ARN) is a unique identifier of the Reserved Instance.
TotalReservedUnits String Total number of units reserved.
CustomerCode String The customer code in CloudBilling.

AWSSavingsPlans

Savings Plans also provide savings beyond on-demand pricing. With Reservations, you make a commitment to a specific instance configuration. With Savings Plans, you have the flexibility to use the instance configurations that best meet your needs. Refer to the external documentation SavingsPlans for more contextual information on what Savings Plans are. The table below contains the Savings Plans details retrieved along with purchases as metadata. Combine this table with the LineItems table to get the Savings Plans details associated with a LineItem.

Name Type Description
Key Integer Primary Key - AWSSavingsPlans.
SavingsPlanArn String The Amazon Resource Name (ARN) is a unique identifier of the Savings Plans.
CustomerCode String The customer code in CloudBilling.

Back to top

Copyright Ⓒ 2011-2025 CloudBilling B.V.