Column Definitions
summary_view
summary_view
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
|
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 |
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:
|
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. |