Structure of CUD subscriptions export

This document provides reference information for the schema of Committed Use Discount (CUD) subscriptions metadata that is exported daily to BigQuery. This export provides a daily snapshot of your spend-based CUDs and Flexible Savings Plans (FSP) commitment metadata to a BigQuery table. You can join this table with other billing data exports for CUD management and reporting.

Ingress and egress rules

If you use VPC Service Controls for BigQuery resources on your project or organization, you must create ingress and egress rules to properly enable data exports to BigQuery.

  1. Create an ingress rule that gives the individual access to create the export: 
    
  - ingressFrom:
      identities:
      - PRINCIPAL_IDENTIFIER_OF_USER_INITIATING_EXPORT
      sources:
      - accessLevel: "*"
  ingressTo:
      operations:
      - serviceName: bigquery.googleapis.com
        methodSelectors:
        - method: "*"
      resources:
      - projects/YOUR_PROJECT_ID_TO_HOST_EXPORT_DATA
  title: 'Ingress Rule Name'

    See Principal identifiers for more information about principal identifier formats.

  2. Create an egress rule to allow Google Cloud access to the BigQuery dataset through VPC Service Controls: 
    
  - egressTo:
       operations:
      - serviceName: bigquery.googleapis.com
        methodSelectors:
        - method: "*"
      resources:
      - projects/132468967293
  egressFrom:
      identityType: ANY_IDENTITY
      sources:
      - accessLevel: "*"
      sourceRestriction: RESTRICTION_STATUS
  title: 'Egress Rule Name'

Schema of the CUD subscriptions export data

In your BigQuery dataset, your Cloud Billing account CUD subscriptions data is loaded into a table named cud_subscriptions_export.

The following table describes the schema of the data that is exported to BigQuery.

Field Type Description
billing_account_id String The 18-character, alphanumeric billing account ID associated with the CUD subscriptions data, for example, 010101-F0FFF0-10XX01.
cud_product.id String The product definition ID, for example, 344fffc1-17f9-4e34-abf2-cfffff409fa2.
cud_product.display_name String The display name of the product associated with the commitment, for example, Flexible Savings Plans.
cud_product.type String The type of commitment, for example, Spend-Based.
consumption_model.id String The ID of the consumption model used by the commitment, for example, 5515-81A8-03A2.
consumption_model.description String The description of the consumption model for the commitment, for example, Vertex AI FSP - 1 Year.
subscription.entitlement_scope String The scope of the entitlement for the commitment, for example, billingAccounts/010101-F0FFF0-10XX01.
subscription.instance_id String The subscription instance ID, which is a GUID, for example, 769c55ea-c50f-4258-bcf5-04b6688fa5fa.
subscription.display_name String The display name for the commitment, defined by you at the time of purchase.
subscription.entitlement_period String The recurrence period of the commitment, either Monthly or Hourly.
subscription.payment_terms String The payment terms for the commitment, for example, Postpay.
region String The region associated with the commitment, for example, us-central1. If the commitment is global, this field is empty.
commitment_amount Repeated Record The commitment amount details.
commitment_amount.unit String The measurement unit of resource consumption for the commitment, for example, $/mo or $/hr.
commitment_amount.value Numeric The commitment amount value.
commitment_fee Record The commitment fee details.
commitment_fee.sku String The SKU ID associated with the commitment fee.
commitment_fee.description String The description of the fee SKU.
term String The term length of the commitment in ISO 8601 duration format, where P1Y represents one year, and P3Y represents three years.
start_time Timestamp The start timestamp for the commitment, for example, 2026-07-20 21:35:48 UTC.
end_time Timestamp The end timestamp for the commitment, for example, 2027-07-20 21:35:48 UTC.
entitlement_schedule Repeated Record The schedule details for the entitlement.
entitlement_schedule.date_start Datetime The start of the schedule window in the America/Los_Angeles time zone.
entitlement_schedule.date_end Datetime The end of the schedule window in the America/Los_Angeles time zone.
entitlement_schedule.commitment_amount Numeric The commitment amount for this specific schedule window.
state String The current status of the commitment, which can be Pending, Active, or Expired.

Cost and pricing reports available in the Google Cloud console