Wave 14 · Data, Reporting & FinOps Operations BigQuery / FinOps / query-cost proof Synthetic project, reservation, and workload exports

BigQuery query-cost posture, slot pressure, and optimization packets that stay operator-readable.

This control plane turns raw BigQuery usage exports into one FinOps surface: bytes-scanned spikes, slot pressure, partition misses, reservation drift, attribution gaps, telemetry issues, and the remediation packets needed before forecast, chargeback, or optimization windows slip.

Overview Query Lane Cost Risks Optimization Posture Verification Docs

Commercial Front Door

BigQuery query-cost governance and workload optimization operations for platform, finance, and analytics teams.
Audit-safe visibility into bytes-scanned spikes, reservation pressure, telemetry gaps, and attribution hygiene without exposing live credentials.

Proof Layer

Offline analyzer + CLI + dashboard surface.
This repo includes a reusable analyzer that reads query-cost snapshots and drift exports and turns them into severity, owner, and optimization packets.

Why it matters

Recruiters looking for BigQuery / FinOps / data platform should see real query-cost work: scan containment, slot governance, attribution hygiene, and export continuity.

Cost Risks

severity · owner · resource

Risk	Owner	Subject	Family	Message
high bytes-scanned-spike	Analytics Engineering	/orgs/kg-prod/projects/shared-analytics/queries/weekly_exec_rollup weekly_exec_rollup.sql	Queries	Bytes-scanned spike on "/orgs/kg-prod/projects/shared-analytics/queries/weekly_exec_rollup" is already pressuring the monthly BigQuery runway by $1,180.
high slot-pressure-surge	Data Platform	/orgs/kg-prod/reservations/analytics-prod analytics-prod	Slots	Slot pressure is active on "analytics-prod" within "/orgs/kg-prod/reservations/analytics-prod" and should be relieved before queue times keep compounding.
high telemetry-gap	Data Platform	/orgs/kg-prod/projects/finance-reporting/exports/billing_feed billing_export_feed	Telemetry	Telemetry coverage is broken on "/orgs/kg-prod/projects/finance-reporting/exports/billing_feed", which weakens downstream query-cost governance and optimization trust.
medium stale-snapshot	Data Platform	/orgs/kg-prod/projects/finance-reporting	—	Workload snapshot for "Finance mart and export feeds" is stale and should be refreshed before certifying query-cost posture.
medium partition-filter-miss	Analytics Engineering	/orgs/kg-prod/projects/shared-analytics/queries/customer_ltv_refresh customer_ltv_refresh.sql	Queries	Partition-filter discipline is missing on "customer_ltv_refresh.sql" and scan efficiency is slipping.
medium reservation-drift	Data Platform	/orgs/kg-prod/reservations/analytics-prod analytics-prod	Slots	Reservation posture on "/orgs/kg-prod/reservations/analytics-prod" is drifting and slot allocation should be rebalanced.
medium reservation-drift	Data Platform	/orgs/kg-prod/reservations/finance-backoffice finance-backoffice	Slots	Reservation posture on "/orgs/kg-prod/reservations/finance-backoffice" is drifting and slot allocation should be rebalanced.
medium low-attribution-coverage	FinOps Operations	/orgs/kg-prod/projects/finance-reporting kg-finance-reporting	Attribution	Attribution coverage is drifting on "/orgs/kg-prod/projects/finance-reporting" and unlabeled BigQuery spend is reducing showback trust.
low stale-optimization-window	Data Platform	/orgs/kg-prod/projects/shared-analytics/queries/customer_ltv_refresh customer_ltv_refresh.sql	Queries	Drift on "/orgs/kg-prod/projects/shared-analytics/queries/customer_ltv_refresh" has remained unresolved for 29 hours.
low stale-optimization-window	Data Platform	/orgs/kg-prod/reservations/finance-backoffice finance-backoffice	Slots	Drift on "/orgs/kg-prod/reservations/finance-backoffice" has remained unresolved for 34 hours.
low stale-optimization-window	Data Platform	/orgs/kg-prod/projects/finance-reporting kg-finance-reporting	Attribution	Drift on "/orgs/kg-prod/projects/finance-reporting" has remained unresolved for 41 hours.
low stale-optimization-window	Data Platform	/orgs/kg-prod/projects/finance-reporting/exports/billing_feed billing_export_feed	Telemetry	Drift on "/orgs/kg-prod/projects/finance-reporting/exports/billing_feed" has remained unresolved for 36 hours.