Column Definitions - Cloud Intelligence Dashboards on AWS

Column Definitions

summary_view

summary_view is a view in Amazon Athena, created on top of Cost and Usage Report CUR, it allow users to have a concise overview of their AWS spend. It provides aggregated insights into costs and usage across various services and accounts.

Column Data Type Description

year

string

Year of the billing period that is covered by report.

month

string

Month of the billing period that is covered by report.

billing_period

timestamp

The start date of the billing period that is covered by this report, in UTC. The format is YYYY-MM-DDTHH:mm:ssZ.

usage_date

timestamp

If Start date is older than 3 months then it converts into first date of month, else actual date.The start date for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ.

payer_account_id

string

The account ID of the paying account. For an organization in AWS Organizations, this is the account ID of the management account.

linked_account_id

string

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.

invoice_id

string

The ID associated with a specific line item. Until the report is final, the InvoiceId is blank, generally after the 6th or 7th of the month (example: June data available after July 6 or 7).

charge_type

string

The type of charge covered by this line item. Some possible types are the following: Credit, Discount, Fee & Refund. For more charge type please refer this Link.

charge_category

varchar(13)

Describes charge category as "running_usage" or "non_usage".In case of Charge type "DiscountedUsage","SavingsPlanCoveredUsage" & "Usage" it converts into "running_usage" else "non_usage".

purchase_option

varchar(11)

Describes the available purchasing models for an AWS service. For example: AWS provides four main Amazon EC2 instance purchasing options: On-Demand, Reserved Instances & Spot Instances.

ri_sp_arn

string

Provides Savings Plan and RI arn, if resource not covered by SP or RI, it returns blank.

product_code

string

The code of the product measured. For example: Amazon EC2 is the product code for Amazon Elastic Compute Cloud.

product_name

string

Describes the full name of the AWS service. Use this column to filter AWS usage by AWS service. Sample values: AWS Backup, AWS Config, Amazon Registrar, Amazon Elastic File System & Amazon Elastic Compute Cloud.

service

string

This identifies the specific AWS service to the customer as a unique short abbreviation including Marketplace. Sample values: Amazon EC2 , AWS KMS, AWS Budgets, AWS Backup & AWS Certificate Manager.

product_family

string

This describes category for the type of product. Sample values: Alarm, AWS Budgets, Stopped Instance, Storage Snapshot & Compute.

usage_type

string

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.

operation

string

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.

item_description

string

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

availability_zone

string

The Availability Zone that hosts this line item. For example: us-east-1a or us-east-1b.

region

string

This describes geographical area that hosts your AWS services. Use this field to analyze spend across a particular Region. Sample values: eu-west-3, us-west-1, us-east-1, ap-northeast-2 & sa-east-1.

instance_type_family

string

This describes the instance family that is associated with the given usage. Sample values: t2, m4 & m3.

instance_type

string

Describes the instance type, size, and family, which define the CPU, networking, and storage capacity of your instance. Sample values: t2.small, m4.xlarge, t2.micro, m4.large & t2.large

platform

string

Describes the operating system of your Amazon EC2 instance. Sample values: Amazon Linux, Ubuntu, Windows Server, Oracle Linux & FreeBSD.

tenancy

string

Describes the type of tenancy allowed on the Amazon EC2 instance. Sample values: Dedicated, Reserved, Shared, NA & Host.

processor

string

Describes the processor on your Amazon EC2 instance. Sample values: High Frequency Intel Xeon E7-8880 v3 (Haswell) & Intel Xeon E5-2670 & AMD EPYC 7571.

processor_features

string

Describes the processor features of your instances. Sample values: Intel AVX, Intel AVX2, Intel AVX512 & Intel Turbo.

database_engine

string

Describes which database engine is being used. Sample Values: Aurora MySQL, Aurora PostgreSQL, Oracle & MySQL.

product_group

string

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.

product_from_location

string

Describes the location where the usage originated from. Sample values: External, US East (N. Virginia) & Global.

product_to_location

string

Describes the location usage destination. Sample values: External & US East (N. Virginia).

current_generation

string

Describes the instance’s generation is current or not, if it is current generation instance, the record will show "Yes" if not it will show "No".

legal_entity

string

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.

billing_entity

string

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.

pricing_unit

string

The smallest billing unit for an AWS service. For example: 0.01c per API call.

resource_id_count

bigint

Count of Distinct ResourceIDs, whereas a ResourceID is an ID of individual 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.

usage_quantity

double

Sum of the amount of usage that you incurred during the specified time period. It specifically covers usage covered by Savings plan and on-demand usage.

unblended_cost

double

Sum of the unblended cost, whereas the UnblendedCost is the UnblendedRate multiplied by the UsageAmount.

amortized_cost

double

Sum of amortized cost, the costs are amortized over the billing period. This means that the costs are broken out into the effective daily rate. AWS estimates your amortized costs by combining your unblended costs with the amortized portion of your upfront and recurring reservation fees.

ri_sp_trueup

double

In case of No Upfront or Partial Upfront Savings Plans, it shows the amount of upfront fee a Savings Plan subscription is costing you for the billing period in negative. The initial upfront payment for All Upfront Savings Plan and Partial Upfront Savings Plan amortized over the current month.

ri_sp_upfront_fees

double

Describes upfront payment of Savings plan and Reserved Instances.

public_cost

double

Sum of 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.