SELECT sum(numBytes) FROM `YOUR-PROJECT-ID.bigquery_views.table_metadata_v1_0`
SELECT count(*) FROM `YOUR-PROJECT-ID.bigquery_views.table_metadata_v1_0`SELECT count(*) FROM `YOUR-PROJECT-ID.bigquery_views.partition_metadata_v1_0`
SELECT projectId, datasetId, sum(numBytes) as totalNumBytesFROM `YOUR-PROJECT-ID.bigquery_views.table_metadata_v1_0`GROUP BY projectId, datasetId ORDER BY totalNumBytes DESC LIMIT 100
SELECT projectId, datasetId, tableId, numBytesFROM `YOUR-PROJECT-ID.bigquery_views.table_metadata_v1_0`sORDER BY numBytes DESC LIMIT 100
SELECT projectId, datasetId, tableId, partitionId, numBytes FROM `YOUR-PROJECT-ID.bigquery_views.partition_metadata_v1_0`ORDER BY numBytes DESC LIMIT 100
