2 Google BigQuery Array (a.k.a. repeated field) & Struct (a.k.a. nested field) for beginners

Рет қаралды 11,755

2 жыл бұрын

In this video, we’ll learn
1. Why do we need to know arrays and structs?
2. Arrays and how to work with them ?
3. Structs and how to combine them with arrays to create nested records ?
Github - github.com/AnandDedha/GCP/blo...
#BigQuery
#GCPBigQuery
BigQuery
BigQuery demo
BigQuery tutorial
BigQuery tutorial for beginners
Email: datatechdemo2@gmail.com

Пікірлер: 12

@juanadearco6356 2 жыл бұрын

Good! I'm studying for the DE exam now and I will only refer to your tutorials.

@eshwargetenv1 9 ай бұрын

so insightful. thanks a lot!

@BogdanDumitru-mj6fh Жыл бұрын

What will be the method to extract a string from the nested 'basic_info' which is within the repeated record 'restaurant' in the last table structure?

@AmitSharma-yi9dr 2 жыл бұрын

great explanation! How does update statement work on an array field in BigQuery table. I am trying to update 1 field in an array. is it possible?

@ganeshkumar3535 2 жыл бұрын

Excellent demo

@DataTechByAnandKumar 2 жыл бұрын

Thanks for your feedback !! Really appreciate it

@praptijoshi9102 Жыл бұрын

What if after column: cuisine_array also we want to map the row Indian with say 4 other rows such as a,b,c,d , the row Casual with e,f,g and StreetFood with null, how will we create that

@theduffrichie2050 Жыл бұрын

great one , only i am struggling with double un nesting to get cuisine info , should have shown that too . nevertheless will read on it .part 2 done , binge watch part 3--> going to next

@theduffrichie2050 Жыл бұрын

dont really get , how do i do double unnest here to get cusini names with casual in it.please help with snippet here if possible . would be much appreciated @datatech

@DataTechByAnandKumar Жыл бұрын

Email me the details.

@maniratnampatchigolla419 2 жыл бұрын

can you please let me know how to unnest the nested arrays ex: [1,2,[3,4],3,4,[2,5],5,6] if possible please provide me the query as i'm completely new to this and i'm learning

@DataTechByAnandKumar Жыл бұрын

Email me the details of your problem.