Skip to content

Instantly share code, notes, and snippets.

@vinoaj

vinoaj/gcp_billing_costs_total_bigquery_costs.sql

Created March 7, 2019 23:35
Show Gist options
  • Save vinoaj/47b0063ac851735cfcdfe7c1755bdc0e to your computer and use it in GitHub Desktop.
Save vinoaj/47b0063ac851735cfcdfe7c1755bdc0e to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery SQL for GCP Billing Reports: Total BigQuery Costs over the last year
Raw
gcp_billing_costs_total_bigquery_costs.sql
#standardSQL
SELECT
project.id
, service.description
, ROUND(SUM(cost),2) AS total_cost
FROM `<project_id>.<dataset_id>.gcp_billing_export_v1_XXXXXX_XXXXXX_XXXXXX`
WHERE _PARTITIONTIME BETWEEN TIMESTAMP(DATE_SUB(CURRENT_DATE(), INTERVAL 365 DAY)) AND TIMESTAMP(CURRENT_DATE())
AND STARTS_WITH(service.description, 'BigQuery')
GROUP BY project.id, service.description
ORDER BY total_cost DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment