bigquery meta data閲覧者の権限が必要
SELECT
dataset_id,
size_gb,
ROUND(size_gb * 0.02, 2) AS monthly_cost_usd,
ROUND(size_gb * 0.02 * 155.4, 2) AS monthly_cost_jpy
FROM (
SELECT table_schema AS dataset_id,
ROUND(SUM(total_logical_bytes) / (1024 * 1024 * 1024), 2) AS size_gb
FROM `region-us`.INFORMATION_SCHEMA.TABLE_STORAGE
GROUP BY dataset_id
)
ORDER BY size_gb DESC;
SQL