Skip to content

Instantly share code, notes, and snippets.

@markrittman

markrittman/query_cost_by_user_by_month.sql

Created June 25, 2021 13:04
Show Gist options
  • Save markrittman/7880d2164e9e844c3799954dcea35230 to your computer and use it in GitHub Desktop.
Save markrittman/7880d2164e9e844c3799954dcea35230 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query_cost_by_user_by_month.sql
```SELECT
date_trunc(date(creation_time),MONTH) as billing_month,
count(distinct job_id) as query_runs,
sum(total_bytes_billed) as total_bytes_billed,
SUM(total_bytes_billed)/1e12*5 costInDollars
FROM
`region-eu`.INFORMATION_SCHEMA.JOBS_BY_PROJECT
WHERE
date_trunc(date(creation_time),MONTH) = '2021-04-01'
AND job_type = "QUERY"
GROUP BY
1
ORDER BY
1 DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment