Delete BigQuery tables with wildcard

Nope, gotta script it. You can delete an entire dataset at once, but there's no way to use a wildcard to delete a subset of the tables in a dataset.


Not the nicest but you can generate a query to delete the tables via:

select concat("drop table ",table_schema,".",   table_name, ";" )
from <insert_your_dataset_name>.INFORMATION_SCHEMA.TABLES
where table_name like "INSERT_YOUR_TABLE_NAME_%"
order by table_name desc

After running that click "Save Results", select "Copy to clipboard" from the dropdown.