<p>I can see metadata details of tables in BigQuery, but for project estimations I'm hoping to see metadata of the entire dataset.</p> <pre class="prettyprint"><code>SELECT * From 'dataset'._TABLES_SUMMARY_WHERE size_bytes>0 isn't working for me. </code></pre>

<pre class="prettyprint"><code>SELECT SUM(size_bytes) AS bytes FROM [yourdataset.__TABLES__] </code></pre>

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.

781

asked Dec 07 '15 17:12

SELECT SUM(size_bytes) AS bytes 
FROM [yourdataset.__TABLES__]

178

answered Sep 19 '22 13:09

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!