FinOps on GCP Complete Guide: BigQuery Billing Export, Labels, and Active Assist

FinOps is an operational framework for maximizing cloud cost and business value together. This article walks through implementing FinOps on GCP across the three stages: Inform / Optimize / Operate.

FinOps 3-Stage Maturity Model

Inform: Building the Visibility Foundation

1. BigQuery Billing Export

# Cloud Billing → Billing Export → BigQuery 有効化
# 結果: <project>.<dataset>.gcp_billing_export_v1_<billing_id>

-- 月別サービス別コスト
SELECT
  invoice.month,
  service.description AS service,
  SUM(cost) AS total_cost,
  SUM(CAST(usage.amount AS NUMERIC)) AS usage,
  usage.unit AS unit
FROM `my-project.billing.gcp_billing_export_v1_BILLING_ID`
WHERE invoice.month = '202605'
GROUP BY 1, 2, unit
ORDER BY total_cost DESC;

2. Label Strategy

• Required labels: env (prod/staging/dev), team, app, cost-center
• Labels can be enforced via Organization Policy
• Label columns are available in the BQ billing export

3. Looker Studio Dashboards

• Wire the BigQuery billing export in as a data source
• Official templates are provided out of the box
• Views by team, app, and month
• Anomaly detection (e.g. alert on +20% month-over-month)

Optimize: Recommendations and Execution

Recommender API Categories

Active Assist Integration

• Bundles Recommender, Policy Analyzer, and Security Health Analytics
• Generates monthly reports automatically
• Integrates with internal systems via Pub/Sub

Operate: Continuous Improvement and Governance

Budget Alerts

# Terraform でプロジェクトごとに Budget
resource "google_billing_budget" "team_alpha" {
  billing_account = "BILLING_ID"
  display_name    = "Team Alpha Budget"

  budget_filter {
    projects = ["projects/team-alpha-prod"]
    labels = { team = "alpha" }
  }

  amount {
    specified_amount {
      currency_code = "USD"
      units         = "5000"
    }
  }

  threshold_rules { threshold_percent = 0.5 }
  threshold_rules { threshold_percent = 0.9 }
  threshold_rules { threshold_percent = 1.0 }

  all_updates_rule {
    pubsub_topic = google_pubsub_topic.budget_alerts.id
  }
}

Quota Limits

• BigQuery Custom Cost Controls (User / Project)
• API Rate Limit
• VM quota (by region / type)

Organization Policy

• Resource location restrictions (block expensive regions)
• VM type restrictions (block expensive machine types)
• Enforce required labels

FOCUS Spec (2024 onward)

• Standard billing schema defined by the FinOps Foundation
• Unifies the format across GCP / AWS / Azure / OCI
• Essential for multi-cloud FinOps
• BigQuery billing export supports FOCUS (GA in 2024)

A Typical FinOps Team

• FinOps Lead (1): strategy and vendor negotiation
• FinOps Analyst (1-2): data analysis and reporting
• Engineering Champion (one per team): drives optimizations
• Finance partner: budget management and charge-back

Case Study: $200K Annual Savings

• Phase 1: BQ billing export + Looker Studio visibility found 50 unused VMs ($30K saved)
• Phase 2: Recommender suggestions and right-sizing saved $40K
• Phase 3: 1-year Flex CUDs saved $80K
• Phase 4: Moving GKE to Spot + Autopilot saved $50K

Note: Google Cloud is a trademark of Google LLC, and the FOCUS Spec is a registered specification of the FinOps Foundation. For the latest information, see the FinOps Foundation official site.