Bigqueryのデータセットのstorage費用を計算するquery

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

发表评论

您的电子邮箱地址不会被公开。 必填项已用 * 标注