๐Ÿฃ
BigQuery Tutorial
  • ๋“ค์–ด๊ฐ€๋ฉฐ
  • BigQuery ์‹œ์ž‘ํ•˜๊ธฐ
    • Legacy SQL vs Standard SQL
    • Hello, BigQuery
    • Simple SELECT Query
  • BigQuery ๋ฐ์ดํ„ฐ ํ˜•์‹
    • Array and Struct
      • Working with Array in BigQuery
      • Array Operations
      • ๋ฐฐ์—ด์•ˆ์˜ NULL ๋‹ค๋ฃจ๊ธฐ
      • Flatten Arrays with UNNEST()
      • Scanning Array
      • ๋ฐฐ์—ด ์ƒ์„ฑํ•˜๊ธฐ
      • Struct in BigQuery
      • Struct ์ƒ์„ฑํ•˜๊ธฐ
      • Struct with Array
      • Array of Struct
      • Nested Table - ๋‚ดํฌ๋œ ํ…Œ์ด๋ธ”
      • Struct ๋กœ Record ๋งŒ๋“ค๊ธฐ
      • Array with Records
      • Flattening Array
      • Example - Working with UNNEST()
      • Example - Querying Nested Arrays
    • JSON in BigQuery
      • What is JSON
      • JSON ์˜ˆ์‹œ
      • JSON ๊ธฐ๋ณธ ๋ฐ์ดํ„ฐ ํ˜•์‹
      • JSON ํ™•์žฅ ๋ฐ์ดํ„ฐ ํ˜•์‹
      • JSON Path
      • JSON ๋‹ค๋ฃจ๊ธฐ
      • JSON Functions
      • JSON Type
      • JSON Examples
      • JSON Type-casting
      • (Legacy) JSON Functions
  • BigQuery ํ•จ์ˆ˜
    • ๋‚ ์งœ์™€ ์‹œ๊ฐ„ ๋‹ค๋ฃจ๊ธฐ
      • TIME ํ˜•์‹
      • DATE ํ˜•์‹
  • [๋ถ€๋ก] Hands-On (outdated)
    • #1 - Kaggle Data Survey
    • #2 - Z Chart Analysis
    • #3 - Fan Chart Analysis
    • #4 - ABC Analysis
Powered by GitBook
On this page
  1. BigQuery ๋ฐ์ดํ„ฐ ํ˜•์‹
  2. Array and Struct

Example - Working with UNNEST()

[๊ทธ๋ฆผ์ถœ์ฒ˜] https://medium.com/firebase-developers/using-the-unnest-function-in-bigquery-to-analyze-event-parameters-in-analytics-fb828f890b42

UNNEST first and JOIN after that

[๊ทธ๋ฆผ์ถœ์ฒ˜] https://medium.com/firebase-developers/using-the-unnest-function-in-bigquery-to-analyze-event-parameters-in-analytics-fb828f890b42
PreviousFlattening ArrayNextExample - Querying Nested Arrays

Last updated 2 years ago