title: Any way to loop through all tables in a dataset in a BigQuery standard SQL script?
body: <p>I have many daily tables (named by _YYYYMMDD suffix) in a dataset. I need to write a daily Scheduled Query to loop through each daily table, perform a join with another dynamically changing table, and overwrite that day's table all in BigQuery. I was looking into "Scripting in standard SQL" and wondered if there might be a way to iterate over _YYYYMMDD tables in a loop?</p>
  
  <p><a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/scripting" rel="nofollow noreferrer">https://cloud.google.com/bigquery/docs/reference/standard-sql/scripting</a></p>
  
  <p>Thanks in advance!</p>