sqlgoogle-bigquerymetadatadatabase-metadata

Viewing Historical Metadata of BigQuery Tables/Datasets


Is there a way to view historical information about BigQuery tables over time? For example, if I wanted to check how the size of a table has changed?

Attempts:
None, because I am unaware if this is doable.


Solution

  • For tables you can now check on TABLE_STORAGE_TIMELINE view with information for all tables in the current or specified project. This view contains metadata about historical table storage usage.