Bigquery Dataset/Table's metadata
google-bigquery
Solution
Thanks N.N. This worked:
SELECT dataset_id, table_id, size_bytes FROM <<>>.TABLES WHERE size_bytes > 0 order by size_bytes desc
Anyway to get created_by?
Problem
Is there a way to programmatically (Java API) get Bigquery's table and dataset metadata? I was trying to create a report on the size, creator, creation time of each tables/datasets and want to avoid doing it manually. We have a lot of tables.