Extract all pattern occurrences in BigQuery

If you ever need to extract information based on a pattern in a BigQuery string, check out the REGEXP_EXTRACT_ALL function. This will return an array of all the occurrences matching the specified regular expression. With regards to the pattern itself...