API Overview
Queryable Properies
All fields you can pass to groupBy, filter, and orderBy across Pelanor API endpoints. Left column = exact property name you must send to the API.
| API Property (enum) | Human‑Readable Name | Description |
|---|---|---|
PaymentKind | Payment Kind | The pricing model for a resource (On Demand, Savings Plan, Reserved Instance, Discount). |
PurchaseOption | Purchase Option | Coverage type for a resource (On Demand, Savings Plan, Reserved Instance, discount‑based). |
QueryType | Query Type | SQL operation (CREATE, SELECT, UPDATE, …). |
CommitmentId | Commitment ID | Identifier of a Savings‑Plan / RI commitment. |
CommitmentAccountId | Commitment Account ID | Account that purchased the commitment. |
CommitmentAccountName | Commitment Account Name | Friendly name of the purchasing account. |
CloudServiceProvider | Vendor | Cloud Service Provider (AWS, GCP, Azure…). |
BillingAccount | Billing Account | Billing account that receives the invoice. |
Subaccount | Subaccount | Child account / project / subscription. |
SubaccountName | Subaccount Name | Friendly name of the sub‑account. |
Region | Region | CSP geographical region (e.g., us‑east‑1). |
AvailabilityZone | Availability Zone | Single data‑centre within a region. |
ServiceName | Service Name | Cloud service (EC2, S3, BigQuery …). |
EntityCategory | Entity Category | Functional category (Compute, Storage, …). |
EntityType | Entity Type | Functional sub‑category (Relational DB, VM …). |
MainEntity | Main Entity | Top‑level resource (bucket, cluster, DB …). |
MainEntityType | Main Entity Type | Entity‑type of that top‑level resource. |
ResourceType | Resource Type | Platform‑agnostic type (VM, Disk, Task, Job). |
ResourceId | Resource ID | Provider‑assigned unique ID. |
ResourceName | Resource Name | Human‑readable resource name. |
InstanceType | Instance Type | Full instance type (m6i.xlarge). |
InstanceFamilyType | Instance Family | Instance family (m6i, t3a). |
UsageCategory | Usage Category | Normalised usage class (Compute, Storage …). |
UsageSubcategory | Usage Sub‑category | Detailed usage class (Internet Egress …). |
UsageKind | Usage Type | CSP‑specific usage string. |
RawUsageKind | Raw Usage Type | Raw usage as emitted by billing engine. |
K8sCluster | Kubernetes Cluster | Name of a K8s cluster. |
K8sNamespace | Kubernetes Namespace | Namespace inside the cluster. |
K8sWorkload | Kubernetes Workload | Deployment / StatefulSet / Job name. |
K8sWorkloadKind | Kubernetes Workload Kind | Workload kind (Deployment, Job, …). |
DatabaseName | Database Name | Name of a database. |
SchemaName | Schema Name | Name of a database schema. |
TableName | Table Name | Table within the database. |
Query | Query Signature | Normalised query fingerprint. |
User | User | Username or principal executing the workload. |
DomainName | Domain Name | Fully‑qualified domain. |
TopLevelDomain | Top‑level Domain | .com, .org, .net, etc. |
CloudfrontDistributionId | CloudFront Distribution ID | ID of a CloudFront distribution. |
CloudfrontOriginId | CloudFront Origin ID | ID of a CloudFront origin. |
CloudfrontObjectPath | CloudFront Object Path | Full object path requested. |
CloudfrontUriFirstSegment | CloudFront URI (first) | 1st URI segment. |
CloudfrontUriSecondSegment | CloudFront URI (second) | 2nd URI segment. |
CloudfrontFileSuffix | CloudFront File Extension | File extension of the request. |
BucketPath | Bucket Path | Object path inside an S3 bucket. |
AwsS3BucketName | S3 Bucket | Name of the bucket. |
AwsS3StorageClass | S3 Storage Class | Storage tier (Standard, Glacier …). |
AwsArn | ARN | Full ARN of an AWS resource. |
Ec2InstanceId | EC2 Instance ID | ID of an EC2 instance. |
AwsAthenaTable | Athena Table | Table referenced in Athena. |
GcpGlobalName | GCP Global Name | Global resource identifier on GCP. |
SnowflakeSchema | Snowflake Schema | Schema in a Snowflake DB. |
SavingsPlanType | Savings Plan Type | Compute vs. EC2‑Instance savings plan. |
AthenaUserRole | Athena User | IAM role executing Athena query. |
AwsAthenaWorkgroup | Athena Workgroup | Workgroup used to run the query. |
AwsAthenaQuery | Athena Query | Normalised Athena query fingerprint. |
BigqueryQuery | BigQuery Query | Normalised BigQuery query fingerprint. |
AwsRedshiftQuery | Redshift Query | Normalised Redshift query. |
AwsEmrJobName | EMR Job Name | Job running on an EMR cluster. |
AwsEmrStatus | EMR Job Status | Job status (Running, Failed …). |
EcsCluster | ECS Cluster | Cluster running ECS tasks. |
EcsService | ECS Service | Long‑running ECS service. |
EcsLaunchType | ECS Launch Type | Fargate vs. EC2 launch type. |
Status | Status | Abstracted job / task status. |
GlueJobName | Glue Job Name | AWS Glue ETL job name. |
ProductName | AWS Product Name | Product as shown in Cost Explorer. |
BillingEntity | Billing Entity | AWS vs. AWS Marketplace billing. |
LineItemDescription | Line‑Item Description | Description from the bill. |
HasGpu | Has GPU | Whether the resource has GPU. |
GpuCost | GPU Cost | Cost segment attributable to GPUs. |
MetricId | Metric ID | Identifier of a custom metric. |
DatabricksClusterId | Databricks Cluster ID | ID of a Databricks cluster. |
Attachment | Volume Attachment Status | Attached vs. Detached EBS volume. |
VolumeType | Volume Type | gp3, io2, standard, … |
Encrypted | Encrypted | Whether the volume is encrypted. |
VpcId | VPC ID | Identifier of a VPC. |
SubnetId | Subnet ID | Identifier of a subnet. |
UnitPrice | Unit Price | Price per billing unit. |
Pipe | Snowpipe Name | Snowflake ingestion pipe. |
ProductFamily | Product Family | Product family string (AWS). |