Skip to content

Instantly share code, notes, and snippets.

@paveljasek

paveljasek/BigQuery - table sizes in a dataset

Created September 14, 2022 13:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save paveljasek/5dd2a16be36e3e20f52362017b8d00ca to your computer and use it in GitHub Desktop.
Save paveljasek/5dd2a16be36e3e20f52362017b8d00ca to your computer and use it in GitHub Desktop.
Download ZIP
Raw
BigQuery - table sizes in a dataset
select table_id, round(sum(size_bytes)/(1024*1024*1024),2) as size_GB
FROM `PROJECT.DATASET.__TABLES__`
group by table_id
union all
select table_id, round(sum(size_bytes)/(1024*1024*1024),2) as size_GB
FROM `PROJECT.DATASET.__TABLES__`
group by table_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment