BigQuery

To find the size of all tables within a dataset

SELECT
  table_id,
  SUM(size_bytes)/(1024*1024*1024) AS size_GB
FROM
  datasetname.__TABLES__
GROUP BY
  table_id
ORDER BY
  size_GB DESC;