Billing Analytics - BigQuery SQL Examples

In addition to the Billing product available within the GCP Console, you may want to export billing data to BigQuery for custom analytics. Below are some example queries to help get you started using the standard data export format. See the links below to learn more about GCP billing datasets including how to export your own billing data for analysis.

The example SQL snippets below reference a sample billing export available as a public dataset in BigQuery (bqutil.billing.billing_dashboard_export). You will need to replace references to this table with your own project and dataset.

Example Queries

Description	Time Period	Additional Dimensions	SQL	Additional Docs
Monthly total costs and credits	monthly	-	Link	-
Monthly invoice total costs and credits	monthly	-	Link	-
Monthly total costs by project	monthly	project	Link	-
Previous month's net-charges per service	monthly	service	Link	-
Previous month’s net-charges by resource label	monthly	label	Link	-
Previous month’s per-service charges by label value	monthly	service,label	Link	-
Monthly CUD/SUD savings	monthly	-	Link	Link
Daily compute usage CUD/SUD coverage	daily	region, unit, project, sku	Link	Link
Previous day's spend per project	daily	project	Link	-
Previous day's spend per GCP Service	daily	service	Link	-
Daily compute usage hours	daily	sku, component	Link	-
Daily compute cost including discount	daily	-	Link	-
Daily average number of cores executed	daily	-	Link	-
Total costs by label value	total	label	Link	-
Total costs by SKU and labels	total	sku, label	Link	-

Useful Links

• Cloud Billing Documentation
• Export Billing Data to BigQuery
• Billing Export Contents