Billing Export

Customers willing to export their Google Cloud billing data are advised to Set up Cloud Billing data export to BigQuery. Note, you will need to have a Billing Account Administrator role for the target Cloud Billing account.
Cloud Management Platform can automatically export detailed billing data (such as usage, cost estimates, and pricing data) to a BigQuery table. Then you can access your billing data from BigQuery for detailed analysis or use a tool such as Looker to visualize your data.
Request Access - You will need to request access to the billing export table by opening a support request at https://support.doit-intl.com. Please provide your Google user, a Google group, or a service account you'd like to use when querying the billing export table
Data Availability
Your billing export table has Cloud Billing data incurred from the date you've joined the DoiT International consolidated billing.
BigQuery loads are ACID compliant, so if you query the BigQuery Cloud Billing export table while data is being loaded into it, you will not encounter partially loaded data.
Project, Dataset, and Table Name
To query the Google Cloud Billing data in BigQuery, you need to specify the table name in the FROM clause. The table name is determined using three values: project.dataset.BQ_table_name.
Project is always doitintl-cmp-gcp-data
Dataset is gcp_billing_ concatenated with the name of your Google Billing account. Dashes in the billing account ID should be replaced with underscores. For example, if your Google Billing Account ID is 006C3F-3613C3-2A2169, the dataset name would be gcp_billing_006C3F_3613C3_2A2169
BQ_table_name is gcp_billing
Table Configuration
Please review the table partitioning and clustering schema to allow query optimization
Table type
Partitioned
Partitioned by
Day
Partitioned on field
export_time
Partition filter
Required
Clustered by
project_id, service_description, sku_description
Sample Queries
This query shows the invoice total for each month since Jan 2020, as a sum of regular costs, credits, adjustments, and rounding errors.
1
SELECT
2
  DATE_TRUNC(DATE(usage_start_time, "America/Los_Angeles"), MONTH) AS month,
3
  (SUM(cost)) - (SUM((
4
      SELECT
5
        SUM(credit.amount)
6
      FROM
7
        UNNEST(credits) AS credit))) AS cost
8
FROM
9
  `doitintl-cmp-gcp-data.gcp_billing_006C3F_3613C3_2A2169.gcp_billing`
10
WHERE
11
  DATE(export_time) >= "2020-01-01"
12
GROUP BY
13
  month
Copied!

Google Cloud - Previous

Google Cloud Quotas

Next - Google Cloud

Import Historical Data

Last modified 3d ago

Copy link

Contents

Data Availability

Project, Dataset, and Table Name

Table Configuration

Sample Queries