If you need help constructing a VQL query, navigate to the Financial Commitment Reports page and click New Report. From the top left, open the Filters menu. Create a filter and click the View as VQL button at the top of the Filters menu to see a filter’s VQL representation. You can copy this syntax to use within your API calls.

​
Financial Commitment Reports VQL Schema

VQL for Financial Commitment Reports comprises one namespace, financial_commitments, which represents the available filters on Financial Commitment Reports in the Vantage console. To reference a filter, use the following syntax: namespace.field (e.g., financial_commitments.service). The following fields are available within the financial_commitments namespace.
NamespaceFieldVQL Example
financial_commitmentsproviderprovider = 'aws' should be added as the first part of each statement
financial_commitmentsserviceService example
financial_commitmentsresource_account_idAccount example
financial_commitmentsprovider_account_idBilling Account example
financial_commitmentscommitment_typeCommitment Type example
financial_commitmentscommitment_idCommitment ARN example
financial_commitmentscost_typeCharge Type example
financial_commitmentscost_categoryCategory example
financial_commitmentscost_sub_categorySubcategory example
financial_commitmentsinstance_typeInstance Type example
financial_commitmentsRegionRegion example
financial_commitmentsresource_tagsTags example

​
Keywords

VQL includes a set of keywords to create complex filter conditions. These keywords function similar to their SQL equivalents. Note that each expression started with provider = 'aws', followed by additional filters.
KeywordDescriptionVQL SampleExplanation
ANDLogical AND operator(financial_commitments.provider = 'aws' AND (financial_commitments.resource_tags->>'business-metric' = 'us-east-1a') AND (financial_commitments.cost_category = 'Alarm'))This example filters for a specific tag and category, where both conditions must be true.
ORLogical OR operator(financial_commitments.provider = 'aws' AND (financial_commitments.resource_tags->>'business-metric' = 'us-east-1a') AND (financial_commitments.resource_tags->>'business-metric' = 'us-east-1b'))This example looks for results associated with two different tags. At least one condition must be true.
!=Is not(financial_commitments.provider = 'aws' AND (financial_commitments.cost_type != 'Credit'))This example looks for results that are any charge type except for Credit.
IN and NOT INUsed to compare against an array/list(financial_commitments.provider = 'aws' AND (financial_commitments.resource_tags->>'business-metric' IN ('us-east-1a','us-east-1b','us-east-1c')))This example searches for results with the business-metric tag key and multiple values. This same query also works for NOT IN where the results are anything matching the tag key except for those particular values: (financial_commitments.provider = 'aws' AND (financial_commitments.resource_tags->>'business-metric' NOT IN ('us-east-1a','us-east-1b','us-east-1c'))).
LIKE and NOT LIKEPerforms string comparisons(financial_commitments.provider = 'aws' AND (financial_commitments.commitment_id LIKE '%arn:aws:ec2%'))This example selects data where the commitment ARN value contains arn:aws:ec2, such as arn:aws:ec2:us-west-2:1234. This same query also works for NOT LIKE where data does not contain a particular string: (financial_commitments.provider = 'aws' AND (financial_commitments.commitment_id NOT LIKE '%arn:aws:ec2%')).
->>This operator is used only when constructing queries related to tags(financial_commitments.provider = 'aws' AND (financial_commitments.resource_tags->>'environment' = 'staging'))This example looks results with the tag name of environment and value of staging.
With these operators and keywords, you can construct complex filter conditions in VQL.

​
VQL Examples

The following examples cover common use cases for VQL.

​
Financial Commitments by Service

Filter for multiple services. 
(financial_commitments.provider = 'aws' AND (financial_commitments.service IN ('AmazonAthena','AmazonCloudFront','AmazonECS')))

​
Financial Commitments by Specific Account

Filter down to an individual account. 
(financial_commitments.provider = 'aws' AND (financial_commitments.resource_account_id = '123456789012'))

​
Financial Commitments by Specific Billing Account

Filter down to an individual billing account. 
(financial_commitments.provider = 'aws' AND (financial_commitments.provider_account_id = '123456789012'))

​
See Specific Commitment Types

Filter out certain commitment types to see everything else. 
(financial_commitments.provider = 'aws' AND (financial_commitments.commitment_type NOT IN ('credit','free')))

​
Financial Commitments by Commitment ARN

See the impact of specific financial commitments related to EC2 by ARNs. 
(financial_commitments.provider = 'aws' AND (financial_commitments.commitment_id LIKE '%arn:aws:ec2%'))

​
Financial Commitments by Charge Type

See only usage-related commitments. 
(financial_commitments.provider = 'aws' AND (financial_commitments.cost_type = 'Usage'))

​
Financial Commitments by Category

All data transfer-related commitments. 
(financial_commitments.provider = 'aws' AND (financial_commitments.cost_category = 'Data Transfer'))

​
Financial Commitments by Subcategory

Filter for Cloudfront and data transfer egress in APN2. 
(financial_commitments.provider = 'aws' AND (financial_commitments.cost_sub_category IN ('APN2-DataTransfer-Out-Bytes','APN2-CloudFront-Out-Bytes')))

​
Financial Commitments by Instance Types

Filter from a list of different instance types. 
(financial_commitments.provider = 'aws' AND (financial_commitments.instance_type IN ('c7a.12xlarge','c7gn.large','c7gn.medium')))

​
Financial Commitments by Region

See all financial commitments outside of us-east-1. 
(financial_commitments.provider = 'aws' AND (financial_commitments.region = 'us-east-1'))

​
Financial Commitments by Tags

Filter based on a specific tag called business-metric and a list of provided values. 
(financial_commitments.provider = 'aws' AND (financial_commitments.resource_tags->>'business-metric' IN ('us-east-1a','us-east-1b','us-east-1c')))

​
Multiple Filters

Complex filter that shows combining two different statements using OR with multiple criteria. 
(financial_commitments.provider = 'aws' AND (financial_commitments.resource_account_id = '123456789012') AND (financial_commitments.service = 'AmazonEC2')) OR (financial_commitments.provider = 'aws' AND (financial_commitments.resource_account_id = '098765432109') AND (financial_commitments.service = 'AmazonRDS'))