Data Dictionary
The table below outlines the columns in Vega's dataset, along with their definitions. This table is a resource to better understand how to analyze FinOps data in the Vega platform, as well as building your own dashboards and reports off of.
Column Name | Definition |
---|---|
application | Tag specific to identifying applications. Vega adds cleaning logic to account for capitalization and spelling errors. |
billing_account_id | Unique identifier for an entity's billing and financial management. |
billing_unit | This is a normalized field that represents how each resource line is billed such as instance hour, GB/hr, request, etc. |
business_group | Name of the high level aggregation of internal organization. |
business_unit | Organizational unit derived from linked account and/or tags. |
channel | The channel a specific resource is associated with. |
client_name | Name of the client. |
closing_month | The calendar month in which the usage occurs. |
cloud_provider | The company or organization offering cloud computing services and resources. For example: AWS, GCP, Azure, etc. |
cloud_provider_identifier | Concatenation of linked account name and ID. |
cloud_region | Name of the region where the resource resides. For example: US East. |
cloud_specific_location | Specific location of the resource. This is a more granular version of cloud region. For example: US East (N. Virginia). |
cost_category | Breaks out billing lines by type, such as Credits, Marketplace purchases, On Demand usage, Savings plan coverage usage, etc. |
coverable_application_type | Represents the type of product category or product cost detail category covered for a resource. |
disk_type | Type of disk used. |
disk_usage_gb | The amount of disk usage in GB. |
environment | This is parsed from the linked account name, resource ID and the tag. |
environment_source | The value that assigns the environment such as tag, linked account, resource, etc. |
financial_owner_email | Email of the financial owner. |
financial_owner_name | Name of the financial owner. |
instance_type | The specific family, size and generation of a particular resource. For example: an AWS EC2 instance such as M5.xlarge. |
is_committed_use_eligible | To check if a resource is eligible for committed use discount. |
lease_ownership_type | Type of lease ownership. |
lease_purchase_month | The calendar month in which the lease is purchased. |
line_item_type | Classification or category used to label and describe individual charges. |
linked_account_id | Unique identifier assigned to an associated account within a platform. |
linked_account_name | Name of the linked account. For example: account name for AWS, subscription name for Azure, and project name for GCP. |
migration | Tag specific to Migration - typically Yes or No. |
migration_origin | Tag specific to Migration which denotes which data center it was migrated from. Vega adds cleaning logic to account for capitalization and spelling errors. |
net_cash | Represents the sum of Gross Cash, Support Fees, Cross Service Discounts, Support Discounts and/or Private Rate Discounts. |
net_fiscal_amount | Amount that includes amortization of upfront cash associated with Committed Use purchases as well as large Marketplaces purchases which are amortized over the term of the agreement. This also includes premium support allocation to each line of billing data as well as any credit allocations and billing error corrections. |
ondemand_cost | The cost/ expense incurred for resources or services that are utilized as needed, without a fixed, ongoing commitment. |
operating_system | The operating system associated with specific usage such as Windows, Linux, Red Hat, etc. |
platform | Name of the platform used/ in use. |
product | Individual product values defined by the cloud provider. For Example: Amazon Elastic Compute Cloud. |
product_category | An aggregation of individual products into natural grouping categories. These apply across AWS, GCP and Azure. For Example: Containers, Data Transfer, Disk storage, etc. This is a more granular version of product group. |
product_cost_detail_category | This is a more granular version of product category which breaks out Data Transfer into items such as AWS Inbound and AWS Outbound. |
product_group | A higher level grouping than product cost detail category. This allows Vega to group individual consumption items into categories across clouds in a way that creates more meaningful aggregations of cloud consumption. |
reporting_month | The length of time for which usage is reported. For example: current, this month, last month, or last year. Note: If the day of the current date is less than or equal to 10, then reporting_month is set as 'current' whereas if it is greater than 10 then the reporting_month is set as 'this month'. |
ri_sp_arn | RI/SP ARNs are used for various purposes, including tagging, policy management, and resource access control. They allow you to reference and work with specific CUD instances within your AWS account. |
savings | Represents the amount of money saved. |
snapshot_origin | Represents the source or point in time from which a snapshot of data or a system state is taken. |
steady_state | This is a Vega defined logic used to check if the resource is running greater than 95% of the available time during a month. This drives specific recommendations such as autoparking. |
technical_owner_email | Email of the technical owner. |
technical_owner_name | Name of the technical owner. |
technical_team_owner | Name of the technical team owner. |
usage_amount | Refers to the quantity or volume of a particular resource, product, service, or item consumed or utilized within a specified period. |
usage_day | The date when the usage occurs. |
usage_type | Raw usage type from cloud provider billing that is a combination field. For example: BoxUsage:c4.xlarge represents instance based usage in AWS of a particular family, region and size type. |