🐣
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 데이터 형식

Array and Struct

PreviousBigQuery 데이터 형식NextWorking with Array in BigQuery

Last updated 1 year ago

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