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...
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...