Skip to content

Instantly share code, notes, and snippets.

@pradyunsg
Created April 16, 2020 17:59
Show Gist options
  • Select an option

  • Save pradyunsg/8a78b7f743fdbcb198bdd8140b1b9a3a to your computer and use it in GitHub Desktop.

Select an option

Save pradyunsg/8a78b7f743fdbcb198bdd8140b1b9a3a to your computer and use it in GitHub Desktop.
Quota Usage with new BigQuery structure
SELECT
COUNT(*) as count
FROM
`the-psf.pypi.file_downloads`
WHERE
DATE(timestamp) between DATE "2020-04-01" and DATE "2020-04-15"
-- This query will process 18.3 GB when run.
SELECT
COUNT(*) as count
FROM
`the-psf.pypi.downloads`
WHERE
DATE(timestamp) between DATE "2020-04-01" and DATE "2020-04-15"
-- This query will process 0 B when run.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment