Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I find a Google BigQuery dataset size, not table sizes?

I can see metadata details of tables in BigQuery, but for project estimations I'm hoping to see metadata of the entire dataset.

SELECT * From 'dataset'._TABLES_SUMMARY_WHERE size_bytes>0 isn't working for me.
like image 781
sadiemac Avatar asked Dec 07 '15 17:12

sadiemac


1 Answers

SELECT SUM(size_bytes) AS bytes 
FROM [yourdataset.__TABLES__]
like image 178
Mikhail Berlyant Avatar answered Sep 19 '22 13:09

Mikhail Berlyant