SQL String Templating in BigQuery Scripts: Four Methods

Powerful foundational techniques to help unlock the power of BigQuery scripting and automation

You should avoid this kind of mess. Photo by Universal Eye on Unsplash

Working with strings in BigQuery became a lot more powerful with the advent of scripting, and specifically the EXECUTE IMMEDIATE statement. This enables you to construct SQL queries as strings and then execute the…