DECLARE and SET variables in BigQuery

Here's a part of procedural language that I use quite a lot in BigQuery. Whether you're looking to run a query based on a multiple values of a particular parameter, finding out the watermark for incremental loading or just doing some testing, you can...