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. |
Related topics
Topics related to exported Cloud Billing data
- Set up Cloud Billing data export to BigQuery
- Example queries for Cloud Billing data export to BigQuery
- Visualize spend over time with Looker Studio
Cost and pricing reports available in the Google Cloud console
- View your Cloud Billing reports and cost trends
- View and download the cost details of your invoice or statement
- View and download prices for Google's cloud services
- Understand your savings with cost breakdown reports
- Analyze the effectiveness of your committed use discounts
- View your cost and payment history