Largest PDTs and Table Size

Using PDTs can be expensive in BigQuery if not done carefully. Here is a query to help you identify the largest PDTs:

select 

  REGEXP_EXTRACT(table_id,r'[A-Z]+_[A-Z0-9]+_(\w+)')

  , table_id

  , row_count

  , size_bytes/pow(10,9) as size

from

  [<dataset>.looker_scratch.__TABLES__]

ORDER BY row_count DESC

Segah Meer

Caura |​ Data Musings