Datasets exist in TABLE_STORAGE view but unable to query

[wcollinscw]

Hi,

I've recently looked into using the INFORMATION_SCHEMA.TABLE_SCHEMA metadata to analyse storage costs ahead of the incoming price rises for BigQuery.

Running the following query: 

select * from `region-europe-west2`.INFORMATION_SCHEMA.TABLE_STORAGE

Returns a lot of rows with dataset names (table_schema) that are not visible in the UI or via a bq show command and do not have the deleted field set to true against them.

These datasets all appear to have active storage against them, but were likely deleted a long time ago.

I am a project owner and just to be sure I have the BigQuery Admin role set against my username.

Why would the TABLE_STORAGE view return these tables? How do I access (and delete) them?

Thanks