I have enabled the GCP cloud billing data to export into bigquery. For GKE I'm not getting all the workloads namespaces into gcp_billing_export table.

I have enabled the GKE Metering, It's created the seperate table called gke_cluster_usage_consumption. Here I'm getting all the workloads data namespace wise.

Why all the workloads data not visible namespace wise in gcp_billing_export table. According the GCP documentation all the namespaces data should be present in both the tables, but gke_cluster_usage_consumption will have some extra columns.

Please help me to understand this

select distinct namespace from table LEFT JOIN UNNEST(labels) as labels ON labels.key = "k8s-namespace"

Thanks in Advance.

I have enabled the GCP cloud billing data to export into bigquery. For GKE I'm not getting all the workloads namespaces into gcp_billing_export table.

I have enabled the GKE Metering, It's created the seperate table called gke_cluster_usage_consumption. Here I'm getting all the workloads data namespace wise.

Why all the workloads data not visible namespace wise in gcp_billing_export table. According the GCP documentation all the namespaces data should be present in both the tables, but gke_cluster_usage_consumption will have some extra columns.

Please help me to understand this

select distinct namespace from table LEFT JOIN UNNEST(labels) as labels ON labels.key = "k8s-namespace"

Thanks in Advance.

• google-cloud-platform
• google-bigquery
• google-kubernetes-engine
• billing

1 Answer 1

gcp_billing_export emphasizes cost, while gke_cluster_usage_consumption tracks consumption metrics. I think not all consumption translates directly to cost. Some resources might be free-tier, or costs might be allocated differently based on discounting, sustained use discounts, or other pricing models. So even if a namespace consumes resources, it might not appear in the billing export if the associated cost is zero or negligible.

Try to analyze the gke_cluster_usage_consumption data for the namespaces you're not seeing in the billing export and determine if those namespaces are actually incurring any costs.