Delete multiple records (DML) (Native SQL)
Native SQL — the SQL runs on the BigQuery side (server-side). Prefix with #DirectSQL to use this mode. Runs a DELETE statement; use your own dataset and table in place of TestDataset.MyTable.
#DirectSQL
DELETE FROM TestDataset.MyTable
WHERE Id > 5