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
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
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
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
Good! I'm studying for the DE exam now and I will only refer to your tutorials.
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?
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?
so insightful. thanks a lot!
Excellent demo
Thanks for your feedback !! Really appreciate it
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
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
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
Email me the details.
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
Email me the details of your problem.