Errata: I flipped OFFSET and SAFE_OFFSET in the video. OFFSET() triggers an error and stops execution if the index is out of bounds. SAFE_OFFSET() returns NULL if the index is out of bounds.
This is the best video on repeated fields I came across. Everything you need to know about BigQuery Arrays in one video. Thank you very much for the easiest explanation.
At 17:40, inside the WITH clause, why is duration_minutes not referenced as trip.duration_minutes? Whereas in the WHERE clause you've used trip.start_time. Not trying to nitpick, I'm new to BigQuery and trying to understand.
Interestingly, Looking at this in 2024 - the 2018 bikes are getting the most use since Jan 2024. more than Double 2021's bikes. 22/23 bikes have been used, but so far not once this year so perhaps those are duds haha
Errata: I flipped OFFSET and SAFE_OFFSET in the video. OFFSET() triggers an error and stops execution if the index is out of bounds. SAFE_OFFSET() returns NULL if the index is out of bounds.
This is the best video on repeated fields I came across. Everything you need to know about BigQuery Arrays in one video. Thank you very much for the easiest explanation.
Świetne wytłumaczenie pracy ze strukturami zagnieżdżonymi!😀
I've been looking for this. I've searched into the documentations and found it hard to comprehend. This is awesome!
Very good explanation, maybe the best I've even seen. Thanks a lot
At 17:40, inside the WITH clause, why is duration_minutes not referenced as trip.duration_minutes? Whereas in the WHERE clause you've used trip.start_time. Not trying to nitpick, I'm new to BigQuery and trying to understand.
This is a really good video. Thanks!
great explanation! Does Bigquery supports update statement for the array or struct fields? I want to update 1 field of an array in a table.
Long time, please make a playlist on big query and its analytical functions
Interestingly, Looking at this in 2024 - the 2018 bikes are getting the most use since Jan 2024. more than Double 2021's bikes. 22/23 bikes have been used, but so far not once this year so perhaps those are duds haha