This solution works fine and only J - max(date) is processed. However, BQ interprets a query with "DECLARE" as a script, so the results can't be exported automatically to a BQ table using scheduled queries. DECLARE maxDate date; SET maxDate = (SELECT Max(date) from destinationTable); SELECT * FROM sourceTable WHERE date >= maxDate