VQL (Vantage Query Language)

• Console. On Cost, Kubernetes Efficiency, Financial Commitment, and Network Flow Reports, as well as Virtual Tag filter configurations and Saved Filters, you can view and edit VQL directly in the filter builder. On Resource Reports, you can view and copy VQL.
• API. On supported endpoints, such as /cost_reports, /resource_reports, /financial_commitment_reports, /kubernetes_efficiency_reports, and /network_flow_log_reports, you can use VQL in the filter parameter to programmatically create and fetch reports.
• Terraform provider. In supported Terraform resources, such as vantage_saved_filter or vantage_cost_report, you can use VQL for the filter argument to create filtered Cost Reports or saved filters.

​

Edit VQL in the Console

    curl --request POST \
        --url https://api.vantage.sh/v2/saved_filters \
        --header 'content-type: application/json' \
        --header 'authorization: Bearer <ACCESS_TOKEN>' \
        --data @- <<EOF
    {
    "filter": "(costs.provider = 'aws' AND costs.service = 'Amazon Relational Database Service') OR (costs.provider = 'gcp' AND costs.service = 'Cloud SQL')",
    "title": "RDS and Cloud SQL",
    "workspace_token": "wrkspc_abcde12345"
    }
    EOF

    resource "vantage_saved_filter" "rds_cloud_sql" {
        title  = "RDS and Cloud SQL"
        filter = "(costs.provider = 'aws' AND costs.service = 'Amazon Relational Database Service') OR (costs.provider = 'gcp' AND costs.service = 'Cloud SQL')"
        workspace_token = "wrkspc_abcde1234"
    }

​

Key Concepts

​

Scopes