Skip to main content
Unomiq can ingest your GCP billing data to provide cost attribution and analysis across your services. To enable this, you need to export your Cloud Billing data to a BigQuery dataset using the detailed usage cost export type. This guide walks you through enabling the detailed billing export in GCP.

Enable Detailed Billing Export

Follow the official GCP documentation to set up the detailed usage cost export to BigQuery:

Export Cloud Billing data to BigQuery

Google Cloud guide covering dataset creation, enabling the export, and GKE cost allocation.
When configuring the export, make sure to:
  • Select the Detailed usage cost export type (not standard)
  • Use a BigQuery dataset with Google-managed encryption (CMEK is not supported)
  • Use a multi-region dataset (US or EU) if you want retroactive backfill of up to five days
If you use Google Kubernetes Engine, you must also enable GKE cost allocation separately to get cost breakdowns by namespace, cluster, and workload.

Verify the Export

After a few hours, verify that data is flowing into BigQuery:
  1. Open the BigQuery console.
  2. Navigate to your dataset.
  3. Look for a table named gcp_billing_export_resource_v1_<BILLING_ACCOUNT_ID>.
  4. Run a sample query to confirm data is present:
SELECT
  invoice.month,
  service.description,
  SUM(cost) AS total_cost
FROM
  `project_id.dataset_id.gcp_billing_export_resource_v1_XXXXXX_XXXXXX_XXXXXX`
WHERE
  invoice.month = FORMAT_DATE('%Y%m', CURRENT_DATE())
GROUP BY
  invoice.month, service.description
ORDER BY
  total_cost DESC
LIMIT 10
Replace project_id.dataset_id and the table name suffix with your actual values.

Important Considerations

  • Data latency: Billing data typically appears in BigQuery within a few hours, but it can take up to 24 hours.
  • Retroactive backfill: When first enabled with a multi-region dataset, GCP backfills up to five days of historical data.
  • Dataset changes: If you change the destination dataset, previously exported data is not automatically migrated to the new dataset.

Next Steps

Once your detailed billing export is active and data is flowing into BigQuery, connect it to Unomiq to start analyzing costs alongside your application traces. See the Unomiq Dashboard to configure the integration.