A couple subtle notes on the BigQuery queries: a) Most date/time functions work with TIMESTAMP, no need to convert to/from DATETIME. b) You can do case-invari

A couple subtle notes on the BigQuery queries: a) Most date/time functions work with TIMESTAMP, no need to convert to/from DATETIME. b) You can do case-invariant regexes for REGEXP_CONTAINS() by prefixing it with (?i), which is more performant than casing w/ UPPER/LOWER beforehand: https://stackoverflow.com/questions/42987537/google-bigquery-possible-to-do-case-insensitive-regexp-match https://stackoverflow.com/questions/42987537/google-bigquery...