Delete all tables matching a grep pattern in a BigQuery dataset

bigquery_delete_multiple_tables.sh

# Delete all tables matching a grep pattern in a BigQuery dataset

DATASET=my_dataset
TABLE_PATTERN=my_table_

# Confirm the table names before deleting
for TABLE in `bq ls --max_results=10000 $DATASET | grep TABLE | grep $TABLE_PATTERN | awk '{print $1}'`; do echo $TABLE; done

# Delete the tables; USE WITH CAUTION!
for TABLE in `bq ls --max_results=10000 $DATASET | grep TABLE | grep $TABLE_PATTERN | awk '{print $1}'`; do echo $TABLE; bq rm -f -t $DATASET.$TABLE; done