The error was because the limit size for a variable is 1MB. Regarding the loop to process batches. You can use the following SQL as a ...
bigquery-while-loop
WHILE condition DO stmts END WHILE. LEAVE label;, LEAVE is not used for GOTO-style blocks; it is used as a synonym for BREAK to leave a WHILE loop.. But the while loop should exit once the proces... 2014-09-22 09:28:23.103000+00:00, 25970485, 1939168, 0. 6, 24757700, I' ... 939c2ea5af
bigquery while loop, bigquery while loop example