Skip to main content
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. You can also edit VQL directly and click Apply to update the filter.

​
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.

​
Keywords

VQL includes a set of keywords to create complex filter conditions. These keywords function similar to their SQL equivalents. The provider condition is optional. The examples below omit it and apply to all connected Financial Commitment Report providers. With these operators and keywords, you can construct complex filter conditions in VQL.

​
Syntax

VQL resembles the WHERE clause of a SQL query. The provider condition is optional. Omit financial_commitments.provider to query all connected providers:
To query a single provider, add its provider value:
To query a subset of providers, use IN:
For provider-specific branches in an OR query, include the corresponding provider condition in each branch:
Use single quotes around string values. See Provider Coverage for the commitments and charge types available for each provider.

​
VQL Examples

The following examples cover common use cases for VQL.

​
Financial Commitments by Service

Filter for services across multiple providers.

​
Financial Commitments by Specific Account

Filter down to an individual account. The account is an AWS account, Azure subscription, or GCP project.

​
Financial Commitments by Specific Billing Account

Filter down to an individual billing account.

​
See Specific Commitment Types

Filter out certain commitment types to see everything else.

​
Financial Commitments by Commitment ID

See the impact of a specific GCP committed use discount by its consumption model ID.

​
Financial Commitments by Charge Type

See only usage-related commitments.

​
Financial Commitments by Category

All data transfer-related commitments.

​
Financial Commitments by Subcategory

Filter for Cloudfront and data transfer egress in APN2.

​
Financial Commitments by Instance Types

Filter from a list of different instance types.
The instance_type field is not populated for GCP.

​
Financial Commitments by Region

See all financial commitments in us-east-1.

​
Financial Commitments by Tags

Filter based on an environment tag and a list of provided values.

​
Multiple Filters

Combine provider-specific statements using OR.

​
Real-World Examples

Find EC2 usage commitments for an account in us-east-1:
Find production commitments that are not credits across all connected providers:

​
Troubleshooting

  • Wrap string values in single quotes, not double quotes.
  • Omit financial_commitments.provider to include all connected Financial Commitment Report providers.
  • Use financial_commitments.provider = 'aws', financial_commitments.provider = 'azure', or financial_commitments.provider = 'gcp' to scope a query to one provider.
  • For provider-specific OR branches, include the corresponding provider condition in each branch.
  • Use financial_commitments.resource_tags->>'KEY' to filter a tag.
  • Keep complete conditions together when mixing AND and OR; use parentheses to separate each branch.