Скачать с ютуб BigQuery Arrays (Repeated Fields) в хорошем качестве

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