Structure of CUD metadata export

This document provides reference information for the schema of Cloud Billing committed use discount (CUD) metadata that's exported daily to each table in BigQuery. This export provides a daily snapshot of your spend-based CUDs commitment metadata to a BigQuery table, which you can join with other billing data exports for better CUD management and reporting.

Schema of the CUD export data

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

The following information describes the schema of the data that's exported to BigQuery.

Field Type Description
billing_account_id String The 18-character, alphanumeric billing account ID associated with the CUD data, for example, 010101-F0FFF0-10XX01.
cud_product.id String The subscription definition ID, for example 344fffc1-17f9-4e34-abf2-cfffff409fa2.
cud_product.display_name String The friendly name of the product associated with the commitment, for example Flexible CUD.
cud_product.type String The type of product commitment, for example Spend-Based.
consumption_model.id String The ID of the consumption model used by the CUD, for example 5515-81A8-03A2.
consumption_model.description String The description of the consumption model for the CUD, for example Cloud Spanner CUD - 1 Year.
subscription.entitlement_scope String The scope of the entitlement for the CUD, for example, an account-scoped entitlement might be 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 CUD, defined by the customer at time of purchase, for example Recommended Cloud Run CUD commitment in us-central1 on Sep 3, 2023.
region String The region associated with the CUD, for example us-central1.
commitent_amount.unit String The measurement unit of resource consumption for the commitment, for example, $/hr.
commitent_amount.value Numeric The commitment amount purchased, for example 100 or 0.05.
term String The term 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 2024-09-27 18:08:20 UTC.
end_time Timestamp The end timestamp for the commitment, for example 2025-02-18 12:11:20 UTC.
state String The state of the commitment, for example Active or Expired.

Cost and pricing reports available in the Google Cloud console