Terry bae의 Data Career 노트

#case 1 Struct구조 데이터셋 생성 WITH array_in_struct AS ( # RECORD/NULLABLE SELECT STRUCT('kyle' as name, ['python','SQL','Scala'] as preferred_language, 31 as age) AS new_struct UNION ALL SELECT STRUCT('max', ['SQL','Go'], 29) ), struct_in_array AS ( # RECORD/REPEATED SELECT ARRAY( SELECT AS STRUCT 'kyle' as name, ['python','SQL','Scala'] as preferred_language, 31 as age UNION ALL SELECT AS STRUCT 'ma..

Bigquery로 엔지니어링 작업을 하는 경우 StructㆍArray 구조 데이터 작업은 매우 중요하다. 개념 정리 차원에서 다음 사이트를 참고하여 실습 및 정리하였음 https://zzsza.github.io/gcp/2020/04/12/bigquery-unnest-array-struct/ #case 1 Array 영역 unnest로 풀었을 때 WITH example_data AS( SELECT 'kyle' AS name, ['Python', 'SQL', 'R', 'Julia', 'Go'] AS preferred_language, 31 AS age UNION ALL SELECT 'max' AS name, ['Python', 'SQL', 'Scala', 'Java', 'Kotlin'] AS preferre..