Column Name | Data Type | Description |
account_number | String | The AWS account ID, a 12-digit number. |
alias | String | The account alias. |
creation_date | Date | Creation Date. |
id | Number | Internally generated unique ID. |
last_updated | Date | Last Updated Date. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
hostname | String | Host address or name. |
id | Number | Unique ID. |
ipaddress | String | IP Address. |
last_updated | Date | Last Updated Date. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
name | String | Specifies the Availability Zone in which an AWS object resides or a charged usage occurred. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
billing_record_id | Number | Internal link to Billing Record. |
creation_date | Date | Creation Date. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
tag_id | Number | Internal link to Billing Record to Tag. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
account_id | Number | Internal link to Account. For consolidated billing accounts, the Linked Account. Otherwise the Payer Account. |
availability_zone_id | Number | Internal link to Availability Zone containing the availability zone in which charged usage occurred. |
blended_cost | Number | Cost for the operation listed in the line item based on the blended rate. |
blended_rate | Number | For consolidated billing accounts, the effective rate for the line item, calculated as an average of the cost of identical Amazon EC2 instances operating in that hour in the same Availability Zone. |
creation_date | Date | Creation Date. |
id | Number | Unique ID. |
invoice_id | Number | Internal link to Invoice containing the AWS invoice number. |
item_description_id | Number | Internal link to Billing Item Description describing the type of usage for this line item. |
last_updated | Date | Last Updated Date. |
operation_id | Number | Internal link to Billed Operation containing operational details of the usage line item. |
payer_account_id | Number | Internal link to Account containing the paying account for the report. |
pricing_plan_id | Number | Numeric ID for the rate listed in the AWS pricing plan for the corresponding service. |
product_id | Number | Internal link to AWS Product containing the long name of the AWS product. |
rate_id | Number | Numeric rate ID that maps to the Item description. The value is assigned by AWS for the Item description, and identifies the billing rate for computation purposes. |
record_id | Number | Unique identifier for each line item. Record IDs are unique for the billing period. |
reserved_instance | String | Indicates whether the line item was calculated at a Reserved Instance rate. Values are Y for Yes and N for No. |
resource_map_id | Number | Internal link to AWS Resource ID to Resource containing the resource id of the resource being billed for. |
subscription_id | Number | Unique identifier for the AWS product described by the line item. |
unblended_cost | Number | Cost for the operation listed in the line item based on the unblended rate. |
unblended_rate | Number | Published rate per hour of operation for the usage type specified in the Item Description field. |
usage_end_date | Date | The end of the applicable charge period. All usage charges and recurring fees between the period start and end are included in your monthly invoice. |
usage_quantity | Number | Computing resources used, in the units specified by each service. |
usage_start_date | Date | The start of the applicable charge period. All usage charges and recurring fees between the period start and end are included in your monthly invoice. |
usage_type_id | Number | Internal link to Billed Usage Type describing the specific usage of the line item. |
via_account_id | Number | Internal link to Collecting Account. |
year_month | Number | Billing period date identifier, an encoded form of year and month (YYYYMM) this invoice is billed for. |
Column Name | Data Type | Description |
attached | Date | When the EBS volume was attached to the EC2 instance. |
creation_date | Date | Creation Date. |
delete_on_termination | String | Indicate if the EBS volume will be deleted when the EC2 instance terminates. |
device | String | Device name. |
ec2_instance_id | Number | Internal link to EC2 Instance. |
ec2_volume_id | Number | Internal link to EC2 EBS Volume. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
status | String | Attachment status, such as attaching, detaching, or detached. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
address_id | Number | Internal link to Network Address. |
attached | Date | When the interface was attached to the EC2 instance. |
creation_date | Date | Creation Date. |
ec2_instance_id | Number | Internal link to EC2 Instance. |
id | Number | Unique ID. |
is_primary | String | Whether the address is the primary address for the EC2 instance, Y or N. |
is_public | String | Whether the address is public on the EC2 instance, Y or N. |
last_updated | Date | Last Updated Date. |
status | String | Interface attachment status, such as attaching, detaching, or detached. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
ec2_instance_id | Number | Internal link to EC2 Instance. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
security_group_id | Number | Internal link to Security Group. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
account_id | Number | Internal link to Account for the owning account. |
architecture | String | Architecture of the instance. |
availability_zone_id | Number | Internal link to Availability Zone where the instance resides. |
creation_date | Date | Creation Date. |
host_id | Number | host_id of apt_host table |
hypervisor | String | Type of hypervisor used, such as ovm or xen. |
id | Number | Unique ID. |
image_resource_id | String | The ID of the Amazon Machine Image (AMI) with which the instance was launched. |
instance_status | String | Instance status, such as initializing or insufficient-data. |
is_ebs_optimized | String | Indicates if the instance is optimized for EBS I/O. |
key_pair_resource_id | String | Key-pair ID used when the instance was launched. |
last_updated | Date | Last Updated Date. |
launched | Date | When the instance was launched. |
monitoring | String | Monitoring state of the instance. |
name | String | AWS Instance Name. |
owner | String | Owner account ID. |
platform | String | Platform of the guest (blank if not Windows). |
region_id | Number | Internal link to Region where the instance resides. |
resource_id | String | AWS EC2 Instance ID. |
root_device | String | Root device name for the instance, such as /dev/sda2. |
root_device_type | String | Root device type, such as ebs or instance-store. |
scope_selector_name | String | Combined AWS Instance Name and Instance ID for display purposes. |
state | String | Instance state, such as stopping or running. |
state_code | Number | Instance state (AWS code). |
system_status | String | System status, such as impaired or initializing. |
tenancy | String | The EC2 instance tenancy type, such as dedicated or shared. |
type | String | Type of instance (determines the instance CPU capacity, memory, and storage). |
via_account_id | Number | Internal link to Collecting Account. |
virtualization | String | Type of virtualization used for the instance. |
vpc_resource_id | String | Virtual Private Cloud (VPC) ID for the instance. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
ec2_instance_id | Number | Internal link to EC2 Instance. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
tag_id | Number | Internal link to EC2 Instance to Tag. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
account_id | Number | Internal link to Account for the owning account. |
creation_date | Date | Creation Date. |
description | String | Snapshot description. |
ec2_volume_id | Number | Internal link to EBS Volume the snapshot is of. |
encrypted | String | Indicates if the volume is encrypted, Y or N. |
id | Number | Unique ID. |
is_current | String | Indicates if the EBS volume is currently at this snapshot. |
last_updated | Date | Last Updated Date. |
name | String | AWS Snapshot Name. |
progress_pct | Number | Snapshot creation progress (percentage represented as 0.00 to 1.00). |
region_id | Number | Internal link to Region where the volume snapshot resides. |
resource_id | String | EBS Volume Snapshot ID. |
started | Date | Date and time when the snapshot creation was started. |
state | String | Snapshot status, such as Pending, Completed, or Error. |
via_account_id | Number | Internal link to Collecting Account. |
volume_size_kb | Number | Size of the EBS volume (KiB) when the snapshot was taken. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
ec2_snapshot_id | Number | Internal link to EC2 EBS Volume Snapshot. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
tag_id | Number | Internal link to EC2 Snapshot to Tag. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
account_id | Number | Internal link to Account for the owning account. |
availability_zone_id | Number | Internal link to Availability Zone in which this volume resides. |
created | Date | Date and time when the EBS volume was created. |
creation_date | Date | Creation Date. |
encrypted | String | EBS Volume encrypted status, Y or N. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
name | String | EBS Volume Name. |
region_id | Number | Internal link to Region in which this volume resides. |
resource_id | String | EBS Volume ID. |
size_kb | Number | Size of the EBS volume (KiB). |
state | String | EBS Volume state, for example Warning or Error. |
type | String | Type of EBS volume. |
via_account_id | Number | Internal link to Collecting Account. |
volume_status | String | EBS Volume status, such as OK, Warning, Impaired, or Insufficient Data. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
ec2_volume_id | Number | Internal link to EC2 EBS Volume. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
tag_id | Number | Internal link to EC2 EBS Volume to Tag. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
account_id | Number | Internal link to Account. |
creation_date | Date | Creation Date. |
id | Number | Internally generated unique ID. |
last_billing_date | Date | Date of the latest Usage Start Date that was collected for this month. |
last_s3_modified_date | Date | Date the S3 object containing the billing records was last modified. |
last_updated | Date | Last Updated Date. |
name | String | The 8-digit identifier for the AWS invoice. This value maps to the invoice number on the PDF file for the corresponding month. If the data is in the current month this field value is Estimated. |
via_account_id | Number | Internal link to Collecting Account. |
year_month | Number | Billing period date identifier. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
name | String | Description of the type of usage for this line item. Includes the average price of any usage that is based on a volume pricing tier. Prices shown are rounded to three decimal places. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
id | Number | Internally generated unique ID. |
last_updated | Date | Last Updated Date. |
name | String | Describes the operational details of the usage line item. For example, a value of RunInstances indicates the operation of an Amazon EC2 instance. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
id | Number | Internally generated unique ID. |
last_updated | Date | Last Updated Date. |
name | String | Long name of the AWS product. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
name | String | Specifies the region in which an AWS object exists. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
ec2_instance_id | Number | Internal link to EC2 Instance (if any). |
ec2_snapshot_id | Number | Internal link to EC2 EBS Volume Snapshot (if any). |
ec2_volume_id | Number | Internal link to EC2 EBS Volume (if any). |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
resource_id | String | The resource ID or name (e.g., EC2 instance ID, S3 bucket name). May be an arbitrary ARN. |
s3_bucket_id | Number | Internal link to S3 Bucket (if any). |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
account_id | Number | Internal link to Account for the owning account. |
created | Date | Date and time the S3 bucket was created. |
creation_date | Date | Creation Date. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
name | String | S3 bucket name. |
owner_id | String | S3 Bucket owner ID. |
owner_name | String | S3 Bucket owner name. |
region_id | Number | Internal link to Region where the S3 bucket resides. |
versioning | String | S3 bucket versioning configuration. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
s3_bucket_id | Number | Internal link to S3 Bucket. |
tag_id | Number | Internal link to S3 Bucket to Tag. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
count | Number | Number of current objects in the S3 bucket. |
creation_date | Date | Creation Date. |
delete_marker_count | Number | Total number of delete markers in the S3 bucket. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
newest_key | String | Newest key of current object in the S3 bucket. |
newest_modified | Date | Newest modification date of current objects in the S3 bucket. |
oldest_key | String | Oldest key of current object in the S3 bucket. |
oldest_modified | Date | Oldest modification date of current objects in the S3 bucket. |
s3_bucket_id | Number | Internal link to S3 Bucket. |
total_count | Number | Total number of objects, including versions, in the S3 bucket. |
total_used_kb | Number | Total used capacity of objects, including versions, in the S3 bucket. |
used_kb | Number | Used capacity of current objects in the S3 bucket. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
name | String | Security group name. |
resource_id | String | Security group ID. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
id | Number | Unique ID. |
key | String | Tag key. |
last_updated | Date | Last Updated Date. |
value | String | Tag value. |
Column Name | Data Type | Description |
creation_date | Date | Creation Date. |
id | Number | Unique ID. |
last_updated | Date | Last Updated Date. |
name | String | Describes the specific usage of the line item. |
via_account_id | Number | Internal link to Collecting Account. |
Column Name | Data Type | Description |
account_number | String | The AWS account ID, a 12-digit number. |
creation_date | Date | Creation Date. |
id | Number | Internally generated unique ID. |
last_updated | Date | Last Updated Date. |