I have a task that needs to delete over a million rows using a key. At first blush, I do not see any bulk or batch delete capabilities. For instance, there are SQL dialects that support syntax like this:
DELETE x FROM schema.table x INNER JOIN filter.table f ON f.key = x.key; Has anyone had a similar need? How have you worked around it? Thanks, Randy
