Cloud Database Views > Amazon Web Services (AWS) Published Views
  
Version 10.1.00
Amazon Web Services (AWS) Published Views
sdk_v_aws_account
The sdk_v_aws_account view contains one row for each Amazon Web Services account.
Table 1 sdk_v_aws_account
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.
sdk_v_aws_address
The sdk_v_aws_address view contains one row for each Amazon Web Services address.
Table 2 sdk_v_aws_address
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.
sdk_v_aws_availability_zone
The sdk_v_aws_availability_zone view contains one row for each Amazon Web Services availability zone.
Table 3 sdk_v_aws_availability_zone
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.
sdk_v_aws_billing_record_tag
The sdk_v_aws_billing_record_tag view contains one row for each Amazon Web Services billing record tag.
Table 4 sdk_v_aws_billing_record_tag
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.
sdk_v_aws_ec2_billing_record
The sdk_v_aws_ec2_billing_record view contains one row for each Amazon Web Services EC2 billing record.
Table 5 sdk_v_aws_ec2_billing_record
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.
sdk_v_aws_ec2_block_dev_map
The sdk_v_aws_ec2_block_dev_map view contains one row for each Amazon Web Services EC2 block dev map.
Table 6 sdk_v_aws_ec2_block_dev_map
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.
sdk_v_aws_ec2_inst_address
The sdk_v_aws_ec2_inst_address view contains one row for each Amazon Web Services EC2 instance address.
Table 7 sdk_v_aws_ec2_inst_address
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.
sdk_v_aws_ec2_inst_secgroup
The sdk_v_aws_ec2_inst_secgroup view contains one row for each Amazon Web Services EC2 instance security group.
Table 8 sdk_v_aws_ec2_inst_secgroup
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.
sdk_v_aws_ec2_instance
The sdk_v_aws_ec2_instance view contains one row for each Amazon Web Services EC2 instance.
Table 9 sdk_v_aws_ec2_instance
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.
sdk_v_aws_ec2_instance_tag
The sdk_v_aws_ec2_instance_tag view contains one row for each Amazon Web Services EC2 instance tag.
Table 10 sdk_v_aws_ec2_instance_tag
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.
sdk_v_aws_ec2_snapshot
The sdk_v_aws_ec2_snapshot view contains one row for each Amazon Web Services EC2 snapshot.
Table 11 sdk_v_aws_ec2_snapshot
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.
sdk_v_aws_ec2_snapshot_tag
The sdk_v_aws_ec2_snapshot_tag view contains one row for each Amazon Web Services EC2 snapshot tag.
Table 12 sdk_v_aws_ec2_snapshot_tag
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.
sdk_v_aws_ec2_volume
The sdk_v_aws_ec2_volume view contains one row for each Amazon Web Services EC2 volume.
Table 13 sdk_v_aws_ec2_volume
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.
sdk_v_aws_ec2_volume_tag
The sdk_v_aws_ec2_volume_tag view contains one row for each Amazon Web Services EC2 volume tag.
Table 14 sdk_v_aws_ec2_volume_tag
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.
sdk_v_aws_invoice
The sdk_v_aws_invoice view contains one row for each Amazon Web Services invoice.
Table 15 sdk_v_aws_invoice
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.
sdk_v_aws_item_description
The sdk_v_aws_item_description view contains one row for each Amazon Web Services item description.
Table 16 sdk_v_aws_item_description
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.
sdk_v_aws_operation
The sdk_v_aws_operation view contains one row for each Amazon Web Services operation.
Table 17 sdk_v_aws_operation
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.
sdk_v_aws_product
The sdk_v_aws_product view contains one row for each Amazon Web Services product.
Table 18 sdk_v_aws_product
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.
sdk_v_aws_region
The sdk_v_aws_region view contains one row for each Amazon Web Services region.
Table 19 sdk_v_aws_region
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.
sdk_v_aws_ec2_resource_map
The sdk_v_aws_ec2_resource_map view contains one row for each Amazon Web Services EC2 resource map.
Table 20 sdk_v_aws_ec2_resource_map
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.
sdk_v_aws_s3_bucket
The sdk_v_aws_s3_bucket view contains one row for each Amazon Web Services S3 bucket.
Table 21 sdk_v_aws_s3_bucket
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.
sdk_v_aws_s3_bucket_tag
The sdk_v_aws_s3_bucket_tag view contains one row for each Amazon Web Services S3 bucket tag.
Table 22 sdk_v_aws_s3_bucket_tag
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.
sdk_v_aws_s3_bucket_usage
The sdk_v_aws_s3_bucket_usage view contains one row for each Amazon Web Services S3 bucket usage.
Table 23 sdk_v_aws_s3_bucket_usage
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.
sdk_v_aws_security_group
The sdk_v_aws_security_group view contains one row for each Amazon Web Services security group.
Table 24 sdk_v_aws_security_group
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.
sdk_v_aws_tag
The sdk_v_aws_tag view contains one row for each Amazon Web Services tag.
Table 25 sdk_v_aws_tag
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.
sdk_v_aws_usage_type
The sdk_v_aws_usage_type view contains one row for each Amazon Web Services usage type.
Table 26 sdk_v_aws_usage_type
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.
sdk_v_aws_via_account
The sdk_v_aws_via_account view contains one row for each Amazon Web Services VIA account.
Table 27 sdk_v_aws_via_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.