BigQuery Arrays (Repeated Fields)

In this video, we go over the array data type in BigQuery SQL. Note that every flavor of SQL has a different set of features, so some BigQuery features described here are not present in others.

**Errata: From 5:24-6:27 I flipped OFFSET and SAFE_OFFSET in the video. OFFSET() triggers an error and stops execution if the index is out of bounds. SAFE_OFFSET() returns NULL if the index is out of bounds.

0:05 What are arrays in BigQuery?
0:41 Why use arrays? Denormalization
1:39 Why use arrays? Avoid dealing with columns/rows
2:48 Creating arrays (ARRAY, ARRAY_AGG, GENERATE_ARRAY)
4:55 Arrays and structs (STRUCT)
5:24 Accessing individual elements (OFFSET, ORDINAL, SAFE_OFFSET)
6:27 Accessing multiple elements (UNNEST)
7:19 Unnest with indexes (WITH OFFSET)
8:18 Flattening arrays (CROSS JOIN UNNEST)
9:52 Scanning arrays (ARRAY_LENGTH, EXISTS, IN)
10:24 Other array operations (ARRAY_TO_STRING, ARRAY_CONCAT, ARRAY_CONCAT_AGG)
11:30 Example array dataset - Austin Bikeshare + BigQuery UI
15:14 Simple example queries on array dataset
16:37 Complex example query on array dataset

Jamboard: https://jamboard.google.com/d/1pUd_YF...
BigQuery Docs:
* https://cloud.google.com/bigquery/doc...
* https://cloud.google.com/bigquery/doc...
* https://cloud.google.com/bigquery/doc...