Skip to main content

CCM Explore

CCM Explore

CCM provides different Explore options with dimensions and measures for each cloud provider. Below is a comprehensive list of available data fields for each provider.

Bill
Field GroupLabel ShortNameDescription
-Bill Typeaws.billtypeThe type of bill that this report covers. There are three bill types: Anniversary (for services used during the month), Purchase (for upfront service fees), and Refund (for refunds).
-Billing Entityaws.billingentityHelps 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.
-Invoice IDaws.bill_invoice_idThe ID associated with a specific line item. Until the report is final, the InvoiceId is blank.
-Payer Account IDaws.awspayeraccountidThe account ID of the paying account. For an organization in AWS Organizations, this is the account ID of the management account.
Billing Period End / DateBilling Period End / Dateaws.billingperiodenddate_dateThe end date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period End / DateBilling Period End / Monthaws.billingperiodenddate_monthThe end date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period End / DateBilling Period End / Month Nameaws.billingperiodenddate_month_nameThe end date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period End / DateBilling Period End / Quarteraws.billingperiodenddate_quarterThe end date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period End / DateBilling Period End / Timeaws.billingperiodenddate_timeThe end date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period End / DateBilling Period End / Weekaws.billingperiodenddate_weekThe end date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period End / DateBilling Period End / Yearaws.billingperiodenddate_yearThe end date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period Start / DateBilling Period Start / Dateaws.billingperiodstartdate_dateThe start date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period Start / DateBilling Period Start / Monthaws.billingperiodstartdate_monthThe start date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period Start / DateBilling Period Start / Month Nameaws.billingperiodstartdate_month_nameThe start date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period Start / DateBilling Period Start / Quarteraws.billingperiodstartdate_quarterThe start date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period Start / DateBilling Period Start / Timeaws.billingperiodstartdate_timeThe start date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period Start / DateBilling Period Start / Weekaws.billingperiodstartdate_weekThe start date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Billing Period Start / DateBilling Period Start / Yearaws.billingperiodstartdate_yearThe start date of the billing period that is covered by this report. Note: the timezone is configurable in widget settings.
Identity
Field GroupLabel ShortNameDescription
-Line Item IDaws.lineitemidThis field is generated for each line item and is unique in a given partition. This does not guarantee that the field will be unique across an entire delivery (that is, all partitions in an update) of the AWS CUR. The line item ID isn't consistent between different Cost and Usage Reports and can't be used to identify the same line item across different reports.
-Time Intervalaws.timeintervalThe time interval that this line item applies to, in the following format: YYYY-MM-DDTHH:mm:ssZ/YYYY-MM-DDTHH:mm:ssZ. The time interval is in UTC and can be either daily or hourly, depending on the granularity of the report.
Line Item
Field GroupLabel ShortNameDescription
-Blended Rateaws.blendedrateThe average rate for each SKU across the entire organization. For example, for EC2 this is the average cost of Reserved Instances and On-Demand Instances. Blended rates are used to allocate costs to member accounts.
-Currency Codeaws.currencycodeThe ISO 4217 code for the currency used in AWS billing (e.g., USD, EUR).
-Legal Entityaws.legalentityThe 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.
-Line Item Descriptionaws.lineitemdescriptionThe 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.
-Line Item Typeaws.lineitemtypeThe type of charge covered by this line item. Possible values include: Credit, DiscountedUsage, Fee, Refund, RIFee, Tax, Usage, and SavingsPlanCoveredUsage.
-Normalization Factoraws.normalizationfactorA factor that normalizes different instance sizes within the same instance family for easier comparison.
-Product Codeaws.productcodeThe code for the AWS product. For example, Amazon EC2 is represented as AmazonEC2.
-Resource IDaws.resourceidResource ID refers to a column that displays the unique identifier of a specific resource you provisioned within your AWS account, like an EC2 instance, S3 bucket, or RDS database, if you choose to include individual resource IDs in your report; essentially, it allows you to pinpoint exactly which resource is associated with a particular cost line item in your billing data.
-Tax Typeaws.taxtypeThe type of tax applied to AWS billing (e.g., sales tax, VAT in CUR).
-Unblended Rateaws.unblendedrateThe unblended rate is the rate associated with an individual account's service usage. For Amazon EC2 and Amazon RDS line items that have an RI discount applied to them, the UnblendedRate is zero. Line items with an RI discount have a LineItemType of DiscountedUsage.
-Usage Account IDaws.aws_usageaccountid_hiddenThe 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.
-Usage Account Nameaws.aws_usageaccountnameAWS account names.
Usage End Time Period / DateUsage End Time Period / Dateaws.end_dateThe end date and time for the corresponding line item in UTC, exclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage End Time Period / DateUsage End Time Period / Monthaws.end_monthThe end date and time for the corresponding line item in UTC, exclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage End Time Period / DateUsage End Time Period / Month Nameaws.end_month_nameThe end date and time for the corresponding line item in UTC, exclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage End Time Period / DateUsage End Time Period / Quarteraws.end_quarterThe end date and time for the corresponding line item in UTC, exclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage End Time Period / DateUsage End Time Period / Timeaws.end_timeThe end date and time for the corresponding line item in UTC, exclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage End Time Period / DateUsage End Time Period / Weekaws.end_weekThe end date and time for the corresponding line item in UTC, exclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage End Time Period / DateUsage End Time Period / Yearaws.end_yearThe end date and time for the corresponding line item in UTC, exclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage Start Time Period / DateUsage Start Time Period / Dateaws.start_dateThe start date and time for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage Start Time Period / DateUsage Start Time Period / Monthaws.start_monthThe start date and time for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage Start Time Period / DateUsage Start Time Period / Month Nameaws.start_month_nameThe start date and time for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage Start Time Period / DateUsage Start Time Period / Quarteraws.start_quarterThe start date and time for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage Start Time Period / DateUsage Start Time Period / Timeaws.start_timeThe start date and time for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage Start Time Period / DateUsage Start Time Period / Weekaws.start_weekThe start date and time for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
Usage Start Time Period / DateUsage Start Time Period / Yearaws.start_yearThe start date and time for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ. Note: the time zone can be configured in widget settings.
-Usage Typeaws.usagetypeThe 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.
Pricing
Field GroupLabel ShortNameDescription
-Lease Contract Lengthaws.leasecontractlengthThe duration of a lease contract for a reserved AWS resource (e.g., 1 year, 3 years for EC2, RDS).
-Public On-Demand Rateaws.publicondemandrateThe public On-Demand Instance rate in this billing period for the specific line item of usage. If you have SKUs with multiple On-Demand public rates, the equivalent rate for the highest tier is displayed. For example, services offering free-tiers or tiered pricing.
-Purchase Optionaws.purchase_optionHow you chose to pay for this line item. Valid values are All Upfront, Partial Upfront, and No Upfront.
-Rate IDaws.rateidThe unique identifier for an AWS pricing rate in billing (e.g., for specific service SKUs).
-Termaws.termSpecifies the billing term for an AWS resource, such as On-Demand, Reserved, or Savings Plan, indicating the commitment level and pricing model
-Unitaws.unitThe pricing unit that AWS used for calculating your usage cost. For example, the pricing unit for Amazon EC2 instance usage is in hours.
Billing & Cost Management
Field GroupLabel ShortNameDescription
Billing & Cost ManagementCapacity Statusaws.awscapacitystatusCurrent status of an AWS resource's capacity (e.g., active, scaling, exhausted).
Billing & Cost ManagementCounts Against Quotaaws.awscountsagainstquotaIndicates if the usage counts against a defined service quota (e.g., 'Yes', 'No').
Billing & Cost ManagementData Transfer Quotaaws.awsdatatransferquotaThe data transfer quota associated with the service or free tier.
Billing & Cost ManagementFee Codeaws.feecodeA unique code identifying a specific AWS service fee in billing.
Billing & Cost ManagementFee Descriptionaws.feedescriptionA human-readable description of a specific AWS service fee in billing.
Billing & Cost ManagementFree Overageaws.awsfreeoverageIndicates if usage is part of a free tier overage.
Billing & Cost ManagementFree Query Typesaws.freequerytypesTypes of queries exempt from charges under AWS free tier or conditions (e.g., Athena, CloudWatch queries).
Billing & Cost ManagementFree Tieraws.awsfreetierDescribes the type of free tier usage (e.g., '12 Months Free', 'Always Free').
Billing & Cost ManagementFree Trialaws.awsfreetrialIndicates if the usage is part of a free trial for a service.
Billing & Cost ManagementFree Usage Includedaws.freeusageincludedThe amount of free usage included in an AWS service offering (e.g., GB, hours in free tier).
Billing & Cost ManagementOfferaws.offerThe specific offer, promotion, or pricing plan applied to the usage.
Billing & Cost ManagementOffering Classaws.offeringclassThe class of AWS reservation offering (e.g., standard, convertible for Reserved Instances).
Billing & Cost ManagementOverage Typeaws.overagetypeThe type of overage charges incurred after exceeding a quota or free tier limit.
Billing & Cost ManagementPricing Unitaws.pricingunitThe pricing unit that AWS used for calculating your usage cost.
Billing & Cost ManagementReserve Typeaws.reservetypeThe type of reservation made.
Billing & Cost ManagementTerm Typeaws.termtypeThe term type for a commitment, such as 'On-Demand' or 'Reserved'.
Billing & Cost ManagementTrial Productaws.trialproductIndicates if the product usage is part of a trial period.
Billing & Cost ManagementUpfront Commitmentaws.upfrontcommitmentThe upfront commitment made for a service or reservation (e.g., 'Yes', 'No').
Compute & Instance Specifications
Field GroupLabel ShortNameDescription
Compute & Instance SpecificationsAccelerator Sizeaws.awsacceleratorsizeThe size or capacity of the hardware accelerator associated with the resource.
Compute & Instance SpecificationsAccelerator Typeaws.awsacceleratortypeThe type of hardware accelerator used, such as GPU, FPGA, or AWS Inferentia.
Compute & Instance SpecificationsCPU Typeaws.awscputypeThe manufacturer or architecture of the CPU, such as 'Intel', 'AMD', or 'AWS Graviton'.
Compute & Instance SpecificationsClock Speedaws.awsclockspeedThe clock speed of the processor for the compute resource, typically measured in GHz.
Compute & Instance SpecificationsCompute Familyaws.awscomputefamilyThe family of the compute resource, such as 'General Purpose' or 'Compute Optimized'.
Compute & Instance SpecificationsCompute Typeaws.awscomputetypeThe specific type of compute resource within a family, often indicating the processor generation or capabilities (e.g., 'Standard', 'High-CPU').
Compute & Instance SpecificationsCurrent Generationaws.currentgenerationIndicates whether an AWS resource or instance is of the current hardware generation (e.g., Yes/No for EC2 m5 vs. m4).
Compute & Instance SpecificationsECUaws.ecuElastic Compute Unit (ECU), a measure of CPU capacity for AWS compute resources (e.g., EC2, Lambda).
Compute & Instance SpecificationsElastic Graphics Typeaws.awselasticgraphicstypeThe type of Elastic Graphics accelerator attached to a Windows instance.
Compute & Instance SpecificationsEngineaws.engineThe core engine powering an AWS service (e.g., EC2 compute, RDS database engine).
Compute & Instance SpecificationsEngine Codeaws.enginecodeA code representing the specific engine version or variant used by an AWS service.
Compute & Instance SpecificationsGPUaws.gpuThe number of GPUs on an instance. This field applies to services like Amazon EC2 and Amazon SageMaker when using GPU-accelerated instances.
Compute & Instance SpecificationsGPU Memoryaws.gpumemoryThe total amount of memory, measured in gigabytes (GB), available on the instance's GPU. This applies to services like Amazon EC2 and Amazon SageMaker. Common values include 16, 32, etc.
Compute & Instance SpecificationsInstanceaws.instanceThe specific instance identifier within AWS services.
Compute & Instance SpecificationsInstance Familyaws.instancefamilyThe family of instance types (e.g., 'm' for general purpose, 'c' for compute optimized).
Compute & Instance SpecificationsInstance Functionaws.instancefunctionThe role or purpose of an AWS instance (e.g., compute-optimized, storage-optimized, web server).
Compute & Instance SpecificationsInstance SKUaws.instanceskuThe Stock Keeping Unit identifier for a specific AWS instance configuration.
Compute & Instance Specifications (continued)
Field GroupLabel ShortNameDescription
Compute & Instance SpecificationsInstance Typeaws.instancetypeThe type of instance used (e.g., t2.micro, m5.large).
Compute & Instance SpecificationsInstance Type Familyaws.instancetypefamilyThe broader family grouping for AWS instance types.
Compute & Instance SpecificationsIntel AVX Availableaws.intelavxavailableIndicates if Intel Advanced Vector Extensions (AVX) are available on the instance.
Compute & Instance SpecificationsIntel AVX2 Availableaws.intelavx2availableIndicates if Intel Advanced Vector Extensions 2 (AVX2) are available on the instance.
Compute & Instance SpecificationsIntel Turbo Availableaws.intelturboavailableIndicates if Intel Turbo Boost Technology is available on the instance.
Compute & Instance SpecificationsMemoryaws.memoryThe amount of memory associated with the resource, typically measured in GB.
Compute & Instance SpecificationsMemory (GiB)aws.memorygibThe amount of memory in gibibytes (GiB) associated with the resource.
Compute & Instance SpecificationsMemory Typeaws.memorytypeThe type of memory used by the resource (e.g., DDR4, GDDR6).
Compute & Instance SpecificationsNetwork Performanceaws.networkperformanceThe network performance capability of the resource (e.g., 'High', 'Moderate', '25 Gigabit').
Compute & Instance SpecificationsPhysical CPUaws.physicalcpuThe number of physical CPU cores available on the instance.
Compute & Instance SpecificationsPhysical GPUaws.physicalgpuThe number of physical GPUs available on the instance.
Compute & Instance SpecificationsPhysical Processoraws.physicalprocessorThe specific model of the physical processor used in the compute resource.
Compute & Instance SpecificationsProcessor Architectureaws.processorarchitectureThe architecture of the processor (e.g., 'x86_64', 'arm64').
Compute & Instance SpecificationsProcessor Featuresaws.processorfeaturesSpecial features or capabilities of the processor.
Compute & Instance SpecificationsTenancyaws.tenancyThe tenancy option for an instance (e.g., 'Shared', 'Dedicated', 'Host').
Compute & Instance SpecificationsvCPUaws.vcpuThe number of virtual CPUs associated with the resource.
Database & Analytics
Field GroupLabel ShortNameDescription
Database & AnalyticsBroker Engineaws.awsbrokerengineThe message broker engine type for a service like Amazon MQ (e.g., RabbitMQ, ActiveMQ).
Database & AnalyticsCache Engineaws.awscacheengineThe type of caching engine used (e.g., Redis, Memcached).
Database & AnalyticsCloudSearch Versionaws.awscloudsearchversionThe API version of the Amazon CloudSearch domain.
Database & AnalyticsDatabase Editionaws.awsdatabaseeditionThe edition of a database used in an AWS service (e.g., SQL Server Enterprise, Oracle Standard, MySQL Community).
Database & AnalyticsDatabase Engineaws.databaseengineThe database engine type used in an AWS service (e.g., MySQL, PostgreSQL, Aurora).
Database & AnalyticsDirectory Sizeaws.directorysizeThe size or edition of the AWS Directory, such as 'Standard', 'Enterprise', or 'Small', which often corresponds to the edition of AWS Managed Microsoft AD.
Database & AnalyticsDirectory Typeaws.directorytypeIdentifies the specific type of AWS Directory Service deployed, such as 'Microsoft AD', 'Simple AD', or 'Shared Microsoft AD'.
Database & AnalyticsDirectory Type Descriptionaws.directorytypedescriptionA detailed explanation of the resource type, such as compute or storage.
Database & AnalyticsHigh Availabilityaws.awshighavailabilityIndicates if the resource is configured for high availability (e.g., 'Multi-AZ').
Database & AnalyticsIndexing Sourceaws.awsindexingsourceThe source for an indexing job, such as in Amazon Kendra.
Database & AnalyticsReal-Time Operationaws.realtimeoperationIndicates if an AWS operation is real-time (e.g., Yes/No for Kinesis, Lambda) in billing.
Database & AnalyticsSupported Modesaws.supportedmodesThe operational modes supported by an AWS service (e.g., On-Demand, Provisioned for Lambda).
Deployment & Architecture
Field GroupLabel ShortNameDescription
Deployment & ArchitectureArchitectural Reviewaws.architecturalreviewIndicates whether an architectural review was conducted for an AWS resource or service.
Deployment & ArchitectureArchitecture Supportaws.architecturesupportLevel of support provided for a specific AWS architecture (e.g., basic, premium).
Deployment & ArchitectureAvailability Zoneaws.availabilityZoneSpecifies the geographical location of the AWS resources, indicating the specific data center within a region where the resource is deployed (e.g., us-east-1a)
Deployment & ArchitectureDeployment Locationaws.awsdeploymentlocationThe location where the application or resource is deployed (e.g., 'Edge', 'Region').
Deployment & ArchitectureDeployment Modelaws.awsdeploymentmodelThe deployment model used, such as 'Single-AZ' or 'Multi-AZ'.
Deployment & ArchitectureDeployment Optionaws.deploymentoptionThe deployment model for an AWS service (e.g., On-Demand, Reserved, Spot, Dedicated Host) affecting cost or usage.
Deployment & ArchitectureMaximum Capacityaws.awsmaximumcapacityThe maximum capacity of a provisioned resource.
Deployment & ArchitectureRunning Modeaws.runningmodeThe operational mode of an AWS resource (e.g., active, standby for RDS, ELB).
Deployment & ArchitectureServer Locationaws.awsserverlocationThe physical location of the server, often more specific than a region.
Deployment & ArchitectureSnowball Typeaws.awssnowballtypeThe type of AWS Snowball device used (e.g., 'Snowball Edge', 'Snowcone').
Geographic & Location
Field GroupLabel ShortNameDescription
Geographic & LocationCountryaws.awscountryThe country where the resource or service is located or where usage originated.
Geographic & LocationFrom Locationaws.fromlocationThe physical or virtual location from which an AWS service is accessed (e.g., region, edge location).
Geographic & LocationFrom Location Typeaws.fromlocationtypeThe type of location from which an AWS service is accessed (e.g., region, availability zone, edge location).
Geographic & LocationGeo Region Codeaws.georegioncodeThe geographic region code for AWS services (e.g., US, EU, APAC).
Geographic & LocationLocationaws.locationThe geographical location of an AWS resource or usage (e.g., us-east-1, global).
Geographic & LocationLocation Typeaws.locationtypeThe type of location for an AWS resource (e.g., region, availability zone, edge location).
Geographic & LocationTo Countryaws.awstocountryThe destination country for data transfer.
Geographic & LocationTo Locationaws.awstolocationThe destination location for data transfer, such as a specific AWS Region or 'Internet'.
Geographic & LocationTo Location Typeaws.awstolocationtypeThe type of the destination location for data transfer, such as 'AWS Region' or 'AWS Edge Location'.
Geographic & LocationTransfer Typeaws.transfertypeThe direction or nature of data transfer, such as inbound or outbound.
Instance Capacity
Field GroupLabel ShortNameDescription
Instance CapacityAwsinstancecapacity10xlargeaws.awsinstancecapacity10xlargeThe compute capacity status or allocation for 10xlarge instances.
Instance CapacityAwsinstancecapacity16xlargeaws.awsinstancecapacity16xlargeThe compute capacity status or allocation for 16xlarge instances.
Instance CapacityAwsinstancecapacity18xlargeaws.awsinstancecapacity18xlargeThe compute capacity status or allocation for 18xlarge instances.
Instance CapacityAwsinstancecapacity24xlargeaws.awsinstancecapacity24xlargeThe compute capacity status or allocation for 24xlarge instances.
Instance CapacityAwsinstancecapacity2xlargeaws.awsinstancecapacity2xlargeThe compute capacity status or allocation for 2xlarge instances.
Instance CapacityAwsinstancecapacity32xlargeaws.awsinstancecapacity32xlargeThe compute capacity status or allocation for 32xlarge instances.
Instance CapacityInstancecapacity12xlargeaws.instancecapacity12xlargeThe compute capacity status or allocation for 12xlarge AWS instances (e.g., vCPUs, availability) for usage tracking.
Instance CapacityInstancecapacity18xlargeaws.instancecapacity18xlargeThe compute capacity status or allocation for 18xlarge AWS instances (e.g., vCPUs, availability) for usage tracking.
Instance CapacityInstancecapacity24xlargeaws.instancecapacity24xlargeThe compute capacity status or allocation for 24xlarge AWS instances (e.g., vCPUs, availability) for usage tracking.
Instance CapacityInstancecapacity4xlargeaws.instancecapacity4xlargeThe compute capacity status or allocation for 4xlarge AWS instances (e.g., vCPUs, availability) for usage tracking.
Instance CapacityInstancecapacity8xlargeaws.instancecapacity8xlargeThe compute capacity status or allocation for 8xlarge AWS instances (e.g., vCPUs, availability) for usage tracking.
Instance CapacityInstancecapacity9xlargeaws.instancecapacity9xlargeThe compute capacity status or allocation for 9xlarge AWS instances (e.g., vCPUs, availability) for usage tracking.