Storage info

select 
  sum(size_bytes)/pow(10,6) as size_in_mb
from
  project-name.dataset_name.__TABLES__
where 
  table_id = 'table_name'