1 thing to be careful when using deletes; delete multiple rows in batches rather than row by row as BQ scans whole table if not clustered or partitioned. 2nd the delete statement may be a bit more complicated with a "not in" clause.