Amazon billing data rollup

After a AWS billing data is downloaded, the data is rolled up and given a set of pivot and aggregate fields.

The rollup is performed for both daily and monthly periods. Pivot fields can be provided in the aws_billing_rollup_pivot table, and aggregate fields can be provided in aws_billing_rollup_aggregate table. Data is stored in the following tables:

  • aws_billling_rollup_daily
  • aws_billling_rollup_monthly

AWS billing reports are driven from these tables. By default, when data download is complete, the billing data rollup runs for the current month. Cost Reports reflect the rollup result.