BigQuery日付別テーブルをまとめてDROPするSQL

1
2
3
4

FOR record IN (SELECT DISTINCT _TABLE_SUFFIX AS table_suffix FROM `dataset.table_*`)
DO
  EXECUTE IMMEDIATE "DROP TABLE `dataset.table_" || record.table_suffix || "`";
END FOR;